Multiselect count for slicer

[Anonymous]

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

Best Regards

alan-li

[Anonymous · Accepted solution]

[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]

It worked. Thank you very much