cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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".

1. When i select a single option:

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

1 ACCEPTED SOLUTION
Microsoft Employee

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.
3 REPLIES 3
Microsoft Employee

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.
Helper I

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.