Create slicer based on DAX

[JB17]

Hi everyone,

Can you help me on the slicer issue I had with my report? How do I create slicer based on measure below? The issue I had is for example when I select Loyal in the slicer, the column is not just showing Loyal category, it also shows other category as well. 

Thanks in advance!

Category Measure_ =

SWITCH(

    TRUE(),

    [Category Sum of Years]=BLANK() || [Category Sum of Years] = 0,"Former & Non-Purchasing",

    [Category Sum of Years]=1 && [YR2023] = 1, "New",

    [Category Sum of Years]=1 || [Category Sum of Years]=2, "Transient",

    [Category Sum of Years]=5,"Loyal",

    [Category Sum of Years]>=3 || [Category Sum of Years]<=4, "Potentially Loyal")

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

1. Add a new table with categories (used as a slicer):

2. Add a secondary measure:

Filter measure (category) = IF(OR( MAX('Table (6)'[Column1])=[Category Measure_],not(ISFILTERED('Table (6)'[Column1]))),1,0)

3. Place the measure as a filter like this:
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/