Forum Discussion
Solved
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 ...
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/
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/