Measure to test for 'Select all' in slicer returns blank

[Laila92]

I have a slicer, and I want the visuals in my report to be blank when nothing is selected. If found different measures in the forum:

1. Slicercheck = ISFILTERED ( 'Deals'[Customer])

2.

SlicerCheck =if(calculate(distinctcount(Deals[Customer]),allselected([Deals[Customer]]))=1,"Y","N")

(My slicer is on column 'Deals'[Customer] )

They both work, except for when I click 'Select All' in the slicer. Then it acts like nothing is selected. Also 

 Selected = ISFILTERED('Deals[Customer])

Returns empty when selecting 'select all'

Any tips? I saw a post from 3 years back with the same issue, and no solution. Maybe something has changed now?

[JeffCarmo]

Hi everyone, 

I look for any solution and in my tests I have found this solution:

Measure 1= 

var _valuesSelectedTable1 = CALCULATE(COUNTROWS([Table1]), ALLEXCEPT([Table1],Table1[Column]))

var _allRowsTable1 = COUNTROWS(ALL(Table1))

var _check =  IF(_valuesSelectedTable1 < _allRowsTable1 -1,TRUE(),FALSE())

return 

IF(_check, "YOUR SELECT VALUES", "ALL VALUES SELECTED")

[jdbuchanan71]

I don't think there is a way to check for that.  It's something that only exists in the slicer.

[v-xicai]

Hi   @Laila92 ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[jdbuchanan71]

Hello @Laila92 

"Select All" is really telling the DAX engine to apply no filter.  2 & 3 are the same thing to DAX.

So ISFILTERED = FALSE means nothing is selected (no filter applied).

[johnmagat]

Do you know how to check if SELECT ALL is selected or not?

[TomMartens · Accepted solution]

Hey @Laila92 ,

can you please elaborate a little more on what will be the difference if "all" available items are selected, meaning checked, instead of none items are selected

From a technical perspective, all items selected has same effect as none items are selected. In both cases, the table and related tables will not be filtered.

Regards,
Tom