Filtering directly on a count measure

Hello Anonymous ,

I would use the switch function and then build the slicer as a table. 

Meaning:

Create a table where you enter the three different status.

Then create three different measures for each card, counting what you want to count (distinct count, differences and common), so you have 6 measures in total. 

Then place the measures on the card visual and fill the slicer with the created table. 

Does that help? If so, please

• mark this post as a solution
• give kudos

Thanks hashtag_pete