Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community
I have problem with filtering the data.
My data has customer ID, customer name, customer branch and a number of other dimensions.
I use card visual for displaying these dimensions and I have filters on all of them.
When I select definite customer id, visual displays related customer name, branch name and others. It is ok.
But when nothing is selected, all dimensions returns first one in the list.
I want do display definite wording "ALL" for all dimensions when nothing is selected. Please help me with formulation.
Solved! Go to Solution.
Hi @OSS ,
To create three meausre to work on it.
BranhM = VAR countrall = CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) ) VAR countr = CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) ) RETURN IF ( countr = countrall, "All", MAX ( 'Customer List'[Branch] ) )
Customer NameM = VAR countrall = CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) ) VAR countr = CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) ) RETURN IF ( countr = countrall, "All", MAX ( 'Customer List'[Customer Name] ) )
RMM = VAR countrall = CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) ) VAR countr = CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) ) RETURN IF ( countr = countrall, "All", MAX ( 'Customer List'[RM] ) )
Hi,
Try this measure
=IF(HASONEVALUE(Data[Customer ID]),VALUES(Data[Client]),"All")
Hope this helps.
@Ashish_Mathur Thank you for your response, but unfortunately I have tried this formula and it doesn't return exactly what I am looking for.
Hi @OSS ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
@v-frfei-msft I have uploaded the sample to one drive.
https://1drv.ms/u/s!Anq8qDsGb04laQas2uox-rnt5wE?e=GFu9BP
I visualise my data with the multiple row card.
I want to write formula and make first row different untill some filter is applied. Actually I use this visual like one row visual and I want to write "ALL" for all dimensions untill definite filter is applied.
May be this is not possible with the multi row card visual. Then please advice me how can I achive this goal.
Best Regards
Hi @OSS ,
To create three meausre to work on it.
BranhM = VAR countrall = CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) ) VAR countr = CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) ) RETURN IF ( countr = countrall, "All", MAX ( 'Customer List'[Branch] ) )
Customer NameM = VAR countrall = CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) ) VAR countr = CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) ) RETURN IF ( countr = countrall, "All", MAX ( 'Customer List'[Customer Name] ) )
RMM = VAR countrall = CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) ) VAR countr = CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) ) RETURN IF ( countr = countrall, "All", MAX ( 'Customer List'[RM] ) )
dear @v-frfei-msft
I have one more question related with this issue.
Taking into consideration the same sample, I want to add one another dimension. I want to add 'Country' dimension which ic connected with my main table via 'Branch' dimension. While adding 'Country' it returns the same input for every selection.
Branch | Country |
New Smyrna Beach (US) | US |
Saguenay (CA) | CA |
Amersham (UK) | UK |
Sweetwater (US) | US |
Stratford (CA) | CA |
Neenah (US) | US |
Chichester (UK) | UK |
Prairie du Chien (US) | US |
Vancouver (US) | US |
Houghton Regis (UK) | UK |
Snodland (UK) | UK |
Grand Haven (US) | US |
Cedar Falls (US) | US |
Thank you very much. It is exactly what I am looking for.
You are great!
Best Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |