Forum Discussion

rampsaladi's avatar
rampsaladi
Frequent Visitor
8 years ago
Solved

Dynamically Calculating Rank based on Slicer

I have the following sample Dataset and I need to be able to rank the SKU based on the $ Amount for a specific time period and product combination. The user wants to see ranks for multiple time perio...
Need Help
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    rampsaladi

     

    Rank =
RANKX (
    ALLSELECTED ( TableName ),
    CALCULATE ( SUM ( TableName[$ Amount] ) ),
    ,
    DESC,
    DENSE
)
Rfranca's avatar
Rfranca
Resolver IV
8 years ago

 

hi, rampsaladi

rankn = RANKX(ALL(tabela[Time Period];tabela[Products];tabela[SKU]);[TT_Amount];;ASC;Dense)

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

rampsaladi

 

Rank =
RANKX (
    ALLSELECTED ( TableName ),
    CALCULATE ( SUM ( TableName[$ Amount] ) ),
    ,
    DESC,
    DENSE
)
  • rampsaladi's avatar
    rampsaladi
    Frequent Visitor
    8 years ago

    Thank you this helps