topic Re: Rankx is not working in DAX Commands and Tips

Rankx is not working

powerbidev123 — Tue, 17 Dec 2024 10:59:54 GMT

Hi Community,

The Rankx function doesnt seem to work. Below is the screenshot.

Can anyone please help what wrong am I doing here

vivek31 — Tue, 17 Dec 2024 11:53:41 GMT

first you can create mesure of total_sales

revenue = SUM(Sales[SalesAmount])

and after you can create rankx measure and use ALL(sales) table.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

johnt75 — Tue, 17 Dec 2024 12:11:12 GMT

You need to use CALCULATE to force context transition

Ranking Sales = RANKX ( ALL ( Orders[Row ID], Orders[Sales] ), CALCULATE ( SUM ( Orders[Sales] ) ), , DESC, DENSE )

madP — Tue, 17 Dec 2024 13:04:00 GMT

Create a measure

revenue = SUM('Table'[sales])

and add new column as below

Ranking_Sales = RANKX(ALL('Table'[RowID],'Table'[sales]), CALCULATE('Table'[revenue]), ,DESC, Dense)