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
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

rampsaladi

 

Infact this one should give the proper results with slicers

 

RANK =
RANKX (
    CALCULATETABLE (
        VALUES ( Table1[Product] ),
        FILTER (
            ALLSELECTED ( Table1 ),
            Table1[Time Period] = SELECTEDVALUE ( Table1[Time Period] )
        )
    ),
    CALCULATE ( SUM ( Table1[Amt] ) ),
    ,
    DESC,
    DENSE
)
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
        Community 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
)