Using a measure as a slicer

Hi,

1. Create a disconnected table with your groups (see figure 1).
2. Create a measure with SWITCH() (figure 2).
3. Create the slicer (figure 3).
4. Use the SWITCH() measure insice your visual.

Figure 1: Disconnected table

Figure 2: SWITCH()

Figure 3: Slicer

Regards Frank AT

cartercambest as FrankAT mentioned, in general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

However, since you are using a Live Connected dataset you can't do this. Is this Live or DirectQuery? Any chance you can switch to composite to add in the extra table you need?

cartercambest 

Generally, a measure can't be used to create slicer directly. There are some workarounds, you can find them in the forum:

https://community.powerbi.com/t5/forums/searchpage/tab/message?filter=location&q=use%20measure%20slicer&noSynonym=false&location=forum-board:power-bi-designer&collapse_discussion=true

However, since you are using live connection datasource. I am afraid current it is not possbile to meet your requirements.

Best, Regards

Paul Zheng