How to distinguish between all selected and none selected for a slicer

[AlexisOlson]

Suppose I have two tables. One data table and one table with values I potentially want to filter out.

Table1   Exclude

ID          ID

1            2

2            5

3

4

5

6

I put Exclude[ID] as a slicer and write a measure to read the slicer and determine if Table1[ID] is to be excluded.

Excluded = IF(MAX(Table1[ID]) IN VALUES('Exclude'[ID]), 1, 0)

This mostly works but returns 1 for every ID in Exclude if no slicer has been selected.

To fix this I added and ISFILTERED condition to my measure.

Excluded = IF(ISFILTERED('Exclude'[ID]) && MAX(Table1[ID]) IN VALUES('Exclude'[ID]), 1, 0)

Seems to work. The above scenario now returns all zeros as I'd expect it to. However, now I have a problem when selecting all. Starting from nothing selected, if I click 2 and then 5 on the slicer, then I get this (which I'd expect):

Weirdly, if instead of selecting the boxes individually, I use the Select All button to select both 2 and 5, then I get all zeros, behaving exactly like I have nothing selected.

The measure has not changed and the slicer looks identical, but I'm getting different results.

How can I make these both give the same result (the former not the latter)? Is this a bug where Power BI doesn't differentiate between all selected and none selected for some reason?

[Zubair_Muhammad]

Hi @AlexisOlson

Interesting observation

Seemingly "SelectAll" button is just the  "clear all selections" button placed inside a Slicer with other items.

So the visual appearance of the slicer should be same when "SelectAll" and "clear all selections" button is pressed

So the SelectAll button should remove the ticks from the Slicer Items just like when we press clear all selections.

[Zubair_Muhammad]

Yes you are right. I overlooked this practical use of ticks.

But technically (for Dax purposes) the SelectALL button means there is no direct filter on the same column [(ISFILTERED(ID) is FALSE)] which is the same as clear all SELECTIONS.

I also have this feeling that it would be more valuable for SELECTALL option to be treated as selection of all items rather than absence of filter

I think a Microsoft Employee will get back to you on this

[AlexisOlson]

I'm not sure I agree. Select All is quite useful when I want to do all-except filtering. I click Select All and deselect the few I don't want to see rather than manually selecting every other option. If it were equivalent to Clear selections, then you couldn't do this.

[risa]

I dont think you got zubair's point. The exclude all functionality can be acheived still in zubair's case if you press cntrl button. but there is no way to distinguish between isfiltered and select all.