topic Return values based on % with DAX in DAX Commands and Tips

Return values based on % with DAX

Sabo256w — Mon, 07 Nov 2022 10:15:01 GMT

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)

johnt75 — Mon, 07 Nov 2022 11:03:29 GMT

Sabo256w — Mon, 14 Nov 2022 07:48:32 GMT

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