Forum Discussion

ramutd54's avatar
ramutd54
Advocate I
8 years ago

RANKX Measure issue

Hi I am facing one problem while  generating ranks based on total requests by date . i am getting different results.

here 2016 june 18  have 48 no of total requests are there .. As per my logic it should be first rank but the rsult is coming  reverse.

date_rank=

Rankx(all(table1(Open Date]),table1[Total Requests],,,Dense) 

here [total Requests] is a calculated measure logic = count( table1.reqno)

here my rank should start from 1 to 48 hPlese help me  how to get the desired ranks...

Need Help

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi ramutd54

     

    Try adding the SORTOrder parameter

     

    date_rank =
RANKX ( ALL ( table1[Open Date] ), [Total Requests],, DESC, DENSE )
    • ramutd54's avatar
      ramutd54
      Advocate I
      8 years ago

       

      After applying   the  above logic i am etting same  rank for all dates..

       

      date_rank = RANKX ( ALL ( table1[Open Date] ), [Total Requests],, DESC, DENSE )

       

       I am geting 1 for all dates

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        Hi ramutd54

         

        And all this happened just by adding "DESC"???  :smileysurprised:

         

        Could you share your file?

         

        Give this a try

         

        date_rank =
RANKX ( ALL ( table1 ), [Total Requests],, DESC, DENSE )