Forum Discussion
Filter changing ranking
Hi!
I created matrix table to see sales of top customers and others.
(I used this video for doing it- https://www.youtube.com/watch?v=-E_5BTPBXQY&t=190s).
1)Created table for top customers and others:
2)Created measure for customer ranking:
3)Created measure to check if customer belongs to top customers or others
Everything is fine if I add all values to matrix (I made matrix for top 15 customers). "Customer Ranking" values are correct and "Top 5 check" ("Top 15 check" in my case) values are correct aswell. Everything is OK even when I use date, country etc slicers.
But as soon as I add measure "Top 5 check" (Top 15 check" in my case) to filters ("TOP 15 check"is 1), then "Ranking" brokes:
Any idea how to fix my DAX measures so ranking would work?