Forum Discussion

rampsaladi's avatar
rampsaladi
Frequent Visitor
8 years ago

Dynamic Rank per Product in Time Period

Hi    I need to be help create a Rank column. I need to be able to generate the rank in the context of the Time Period for the Products based on the Amount and This rank will be in the context of t...
Need Help
Show and Tell
rampsaladi's avatar
rampsaladi
Frequent Visitor
8 years ago

This is really helpful you know I never thought of it, but I have one more request can I actually have a different rank measure for each Time Period, the only reason i ask it I have other measure values that I need to dsiplay along with Rank and if I add them its get little bit skewed. the look. So Ideally I would like to have a Rank Measure for Say latest 13 Weeks timeperiod data and this will change based on the Market Slicer

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi rampsaladi

 

In that case try his pattern

 

RANK_Last 13 Week =
RANKX (
    ALLSELECTED ( Table1[Product] ),
    CALCULATE ( SUM ( Table1[Amt] ), Table1[Time Period] = "Last 13 Week" ),
    ,
    DESC,
    DENSE
)