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

Thank you for providing the information but the DAX you provided does not give me the correct result, it always gives rank as 1

  • 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