Filter top customers who makes 50%, 80% of total sales

[Anonymous]

Hi! 

I want to show table of only customers that comprises 50 or 80% of total sales. 

I created Share and Rank measures, but now don't know how to create another measure that will sort out only certain percantage of top customers. Help me please 🙂 

[Sergii24]

Hi @Anonymous, I would suggest you to carefully read this article  - ABC classification – DAX Patterns. It descrbes step-by-step how to obtain a residered result. Good luck! 🙂