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 Team,
I need a little help with slicer.
I've a slicer which consists of multiple values. So when i select on a single value from the slicer it should display the respective result. But when I use "select all" option it should display on the card "All".
For your reference:
1. When i select a single option:
2. When i select "Select All' this is the desired output:
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous
You may try below measure:
Measure = VAR a = CALCULATE ( DISTINCTCOUNT ( Table1[city] ), ALLSELECTED ( Table1 ) ) VAR b = CALCULATE ( DISTINCTCOUNT ( Table1[city] ), ALL ( Table1 ) ) RETURN IF ( a = b, "ALL", MAX ( Table1[city] ) )
Regards,
Hi @Anonymous
You may try below measure:
Measure = VAR a = CALCULATE ( DISTINCTCOUNT ( Table1[city] ), ALLSELECTED ( Table1 ) ) VAR b = CALCULATE ( DISTINCTCOUNT ( Table1[city] ), ALL ( Table1 ) ) RETURN IF ( a = b, "ALL", MAX ( Table1[city] ) )
Regards,
HI, i need to use the same dax :
FILTER_label =
VAR a =
CALCULATE ( DISTINCTCOUNT ( TABLE[PRODUCT] ), ALLSELECTED ( TABLE) )
VAR b =
CALCULATE ( DISTINCTCOUNT ( TABLE[PRODUCT] ), ALL ( TABLE ) )
RETURN
IF ( a = b, "MASTER", TABLE[PRODUCT])
My B value is 71 and never change even when I choose any PRODUCT from Slicer, that's ok , and A value change depend of what PRODUCT I select (67, 4, etc) that's ok, but the IF stay in MASTER, never change. Any suggest?
Hi Valentina,
The solution is to create a measure that provides that information. There are several options/ways to do this and several considerations. have a look at this great article.
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |