Skip to main content
cancel
Showing results for 
Search instead 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

Reply
DOBRITONZ
Frequent Visitor

DAX ISFILTERED doesn't recognize "Select All" scenario on the slicer

Hi 

 

As  below, I need fo find a way to identifity that the user have chosen the "Select All" option on the slicer.

When I use ISFILTERED funcition it returs True if I select all item but not the select all, on the right. But like on the left side when I choose "Select All" the function returns False.

 

 

DOBRITONZ_0-1677704060565.png

 

https://drive.google.com/drive/folders/1GCp-ONlUvIgcFOah8htkH2WKSl-qv5B5?usp=sharing

 

 

Any advice please on how to sort this out ?

 

PBI file on the link.

 

Thanks,

2 REPLIES 2
Arul
Super User
Super User

@DOBRITONZ ,

I hope the workaround in this thread might help you.

https://community.powerbi.com/t5/Desktop/A-solution-for-the-quot-ISFILTERED-SELECT-ALL-quot-Problem/...

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Hi @Arul 

 

Thanks for this, I saw this article but it isn't straigthfoward and as I'm using DQ mode with parameters, it makes things more complicated.

 

I'll log an issue as you mention.

 

 

Cheers,

Douglas

 

Helpful resources

Announcements
Europe Fabric Conference

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.