Filter changing ranking

Hi PowerK ,

If I understand correctly, the issue is that you want to rank the customers and others. Could you please provide more raw data(exclude sensitive data) with Text format to make a deep troubleshooting? It would be helpful to find out the solution.

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

Looking forward to your reply.

Best Regards,

Wisdom Wu

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?