Forum Discussion

StevenT's avatar
StevenT
Helper V
1 year ago
Solved

Creating Rank

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('TrackSal...
Need Help
  • anmolmalviya05's avatar
    anmolmalviya05
    1 year ago

    Hi StevenT,
    Please try the below measure:

    Rank =

    RANKX(

    ALL('PurchasedFrom'),

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

    DESC,

    DENSE

    )

     

  • johnt75's avatar
    johnt75
    1 year ago

    Try

    Ranking =
VAR PurchasedFromWithSales =
    ADDCOLUMNS (
        ALLSELECTED ( 'PurchasedFrom'[pkPurchasedFrom] ),
        "@sales", CALCULATE ( SUM ( 'TrackSales'[SalesAmt] ) )
    )
VAR Result =
    RANK ( DENSE, PurchasedFromWithSales, ORDERBY ( [@sales], DESC ) )
RETURN
    Result
johnt75's avatar
johnt75
Super User
1 year ago

Try

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