Forum Discussion

Sabo256w's avatar
Sabo256w
Frequent Visitor
3 years ago
Solved

Return values based on % with DAX

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)