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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.