cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Create slicer based on DAX

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.

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")
1 ACCEPTED SOLUTION
Super User

Hi,

Here is one way to do this:

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

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!

Proud to be a Super User!

Super User

Hi,

Here is one way to do this:

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

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!

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.