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

 

GIve this MEASURE a shot as well

 

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