Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Multiselect count for slicer

hi all

 

I had a problem with the tool tip, I have a slicer and sometimes I want to select multiple options, and then I want to record how many options I chose, is this possible to solve with the DAX function

 

Just like in the picture

choose.png

 

Best Regards

alan-li

1 ACCEPTED SOLUTION
Anonymous
Not applicable

[Num Of Options Chosen] =
COUNTROWS( VALUES( UnderlyingSlicerTable[TheFieldExposedInSlicer] ) )

If you want to distinguish between all options selected and none (which is the same), then you have to use some conditional logic with ISFILTERED( UnderlyingSlicerTable[TheFieldExposedInSlicer] ).

 

Best

D.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

[Num Of Options Chosen] =
COUNTROWS( VALUES( UnderlyingSlicerTable[TheFieldExposedInSlicer] ) )

If you want to distinguish between all options selected and none (which is the same), then you have to use some conditional logic with ISFILTERED( UnderlyingSlicerTable[TheFieldExposedInSlicer] ).

 

Best

D.

Anonymous
Not applicable

It worked. Thank you very much

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors