cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Laila92
Helper V
Helper V

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

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?

1 ACCEPTED SOLUTION
TomMartens
Super User II
Super User II

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
v-xicai
Community Support
Community Support

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
Super User II
Super User II

Hello @Laila92 

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

2020-04-22_13-26-56.jpg

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

TomMartens
Super User II
Super User II

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors