topic Re: Use slicer as selector - show no selections when no slicer option active in DAX Commands and Tips

Use slicer as selector - show no selections when no slicer option active

Anonymous — Tue, 06 May 2025 08:18:52 GMT

I want to use a slicer as a selector, displaying no selections when no slicer option is checked, and all when select all is checked.

I use the following measure to count no. of selections:

SelectedOptionCount = VAR SelectedOptions = COUNTROWS (ALLSELECTED (...)) VAR TotalOptions = COUNTROWS (ALL((...))) RETURN IF (SelectedOptions = TotalOptions||ISBLANK(SelectedOptions), 0, SelectedOptions)

The card on the right has field SalesOption. The filter, SelectOptionCount > 0, on it ensures no selections show when the slicer is inactive. However, SelectOptionCount is 0 when I select all with my current measure:

Re: Use slicer as selector - show no selections when no slicer option active

bhanu_gautam — Tue, 06 May 2025 09:07:55 GMT

Anonymous , Try using

DAX
SelectedOptionCount =
VAR SelectedOptions = COUNTROWS (ALLSELECTED (...))
VAR TotalOptions = COUNTROWS (ALL((...)))
RETURN
IF (SelectedOptions = TotalOptions, TotalOptions, IF(ISBLANK(SelectedOptions), 0, SelectedOptions))

Re: Use slicer as selector - show no selections when no slicer option active

johnt75 — Tue, 06 May 2025 09:29:30 GMT

Try

IF ( (SelectedOptions = TotalOptions && NOT ISFILTERED(...) ) ||ISBLANK(SelectedOptions), 0, SelectedOptions)

Re: Use slicer as selector - show no selections when no slicer option active

Anonymous — Thu, 08 May 2025 10:19:27 GMT

The measure displays as 0 in the card, but the filter >0 doesn't work for some reason

Re: Use slicer as selector - show no selections when no slicer option active

v-achippa — Tue, 13 May 2025 07:00:56 GMT

Hi Anonymous,

Thank you for reaching out to Microsoft Fabric Community.

Try this below measure:

SelectedOptionCount =
VAR SelectedOptions = COUNTROWS(VALUES('Sales'[SalesOption]))
VAR TotalOptions = COUNTROWS(ALL('Sales'[SalesOption]))
RETURN
SWITCH(
TRUE(),
SelectedOptions = 0, BLANK(),
SelectedOptions = TotalOptions && NOT HASONEFILTER('Sales'[SalesOption]), BLANK(),
SelectedOptions
)

This will Return BLANK() when nothing is selected or when Select All is selected but no real filter is applied. Return count when actual filtering is done.

Apply a visual level filter SelectedOptionCount is not blank. This ensures the visual appears only when the user actively selects options.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks and regards,

Anjan Kumar Chippa

Re: Use slicer as selector - show no selections when no slicer option active

Anonymous — Wed, 14 May 2025 10:10:09 GMT

I want to distiguish between 'Select all' and select nothing. This formula is more complicated but results in this:

Re: Use slicer as selector - show no selections when no slicer option active

v-achippa — Thu, 15 May 2025 07:47:10 GMT

Hi Anonymous,

Here is the updated measure, it will distinguish all the cases:

SelectedOptionStatus =

VAR SelectedCount = COUNTROWS(VALUES('Sales'[SalesOption]))

VAR TotalCount = COUNTROWS(ALL('Sales'[SalesOption]))

RETURN

SWITCH(

TRUE(),

SelectedCount = 0, "Nothing Selected",

SelectedCount = TotalCount && NOT ISFILTERED('Sales'[SalesOption]), "All Selected (No Filter)",

SelectedCount = TotalCount, "All Selected (Manual)",

"Filtered Selection"

)

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks and regards,

Anjan Kumar Chippa

Re: Use slicer as selector - show no selections when no slicer option active

Anonymous — Fri, 16 May 2025 14:00:24 GMT

It always returns 'Filtered Selection'. I believe that because this slicer is affected by another in a previous page. Is there a workaround?

Re: Use slicer as selector - show no selections when no slicer option active

v-achippa — Tue, 20 May 2025 10:29:19 GMT

Hi Anonymous,

Please try this below approach:

Create a disconnected table and use this in the slicer instead of the original one i.e 'Sales'[SalesOption]. Now use this below measure to detect the slicer status:

SelectedOptionStatus =

VAR TotalOptions = COUNTROWS(ALL('SalesOptions_Disconnected'))

VAR SelectedOptions = COUNTROWS(VALUES('SalesOptions_Disconnected'))

RETURN

SWITCH(

TRUE(),

SelectedOptions = 0, "Nothing Selected",

SelectedOptions = TotalOptions, "All Selected",

SelectedOptions < TotalOptions, "Filtered Selection",

"Other"

)

This avoids interaction from other slicers or pages and gives the expected output.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks and regards,

Anjan Kumar Chippa