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

Zubair_Muhammad

yes I can see that but It does not work when I do it but let me try again.  I also have another requirement where I need to be able to display the Rank for each time period side by side and I tried to do that by filterting the data for the specific time period but it did not work. Any help is appreciated. 

 

Basically I need to show a side by side comparison of the Product Rank over time period in a specific market

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

    Hi rampsaladi

     

    to show a side by side comparison of the Product Rank over time period in a specific market.....

    You can try using this rank MEASURE

     

    RANK_ =
RANKX (
    ALLSELECTED ( Table1[Product] ),
    CALCULATE ( SUM ( Table1[Amt] ) ),
    ,
    DESC,
    DENSE
)

     

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

      rampsaladi

       

      Use a Matrix Table...Put Time Period in Columns..Products in Rows and RANK measure in values

       

       

       

      • 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