cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Need help with slicer "Select All" option.

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:

Capture.PNG

2. When i select "Select All' this is the desired output:

 

Capture.PNG

Thanks in advance!

1 ACCEPTED SOLUTION
v-cherch-msft
Microsoft
Microsoft

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-cherch-msft
Microsoft
Microsoft

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

Anonymous
Not applicable

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.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors