Creating Rank

[StevenT]

hI, I'm having trouble creating rank for my data.

Here's the table I'm using.|
Here's the DAX measure I created. 

   

 RANKX(ALL('PurchasedFrom'),'PurchasedFrom'[pkPurchasedFrom],SUM('TrackSales'[SalesAmt]),DESC,Dense)

I'm sure I made a mistake in the code but not sure what.
PurchasedFrom table is linked to trackList and SalesAmt is also linked to TrackList.
Tracklist contains millions of records and so the $ is accurate but I just can't get the Ranking to work properly.

[anmolmalviya05 · Accepted solution]

Hi @StevenT,
Please try the below measure:

Rank =

RANKX(

ALL('PurchasedFrom'),

CALCULATE(SUM('TrackSales'[SalesAmt])),

DESC,

DENSE

)

[johnt75 · Accepted solution]

Try

Ranking =
VAR PurchasedFromWithSales =
    ADDCOLUMNS (
        ALLSELECTED ( 'PurchasedFrom'[pkPurchasedFrom] ),
        "@sales", CALCULATE ( SUM ( 'TrackSales'[SalesAmt] ) )
    )
VAR Result =
    RANK ( DENSE, PurchasedFromWithSales, ORDERBY ( [@sales], DESC ) )
RETURN
    Result

[anmolmalviya05 · Accepted solution]

Hi @StevenT,
Please try the below measure:

Rank =

RANKX(

ALL('PurchasedFrom'),

CALCULATE(SUM('TrackSales'[SalesAmt])),

DESC,

DENSE

)

[StevenT]

Thanks very much for your help!