Return values based on % with DAX

[Sabo256w]

Hi All, 

I'm having an issue I can't solve. 

I have a table with Clients and Revenue. 

I have a simple measure that calculates 80% of the Total Revenue

    0.8 * [Revenue]

I want to return only the top clients that are within the 80% of the revenue (e.g the top clients that make up 2000 - Top being based on the revenue) 

[Sabo256w]

Thanks! This took me down a rabbit hole of exploring and I found this that solved my issue: TopPercent in DAX – Unplugged #8 - SQLBI

[johnt75 · Accepted solution]

Have a look at https://www.daxpatterns.com/abc-classification/