Rankx is not working

[powerbidev123]

Hi Community,

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

Can anyone please help what wrong am I doing here

[madP]

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)

[johnt75 · Accepted solution]

You need to use CALCULATE to force context transition

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

[vivek31]

Hi @powerbidev123 ,

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.