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 s...
Need Help
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 )

     

     

    • ramutd54's avatar
      ramutd54
      Advocate I
      8 years ago

      Hi   Zubair Mohammad,

       

      after couple of  testings finally i have  got  the desired output. the logic below is 

       

      rank_date = rankx(allselected( table1[Open Date]),calculate(count(table1[Req. No.])),,,Dense)

       

      There's no filters in this report. here i have appliced year slicer and also the dats is changing dynamically as  expected...

       

      now i want to implement another concept  with this result. 

       

      i want to  filter the ranks based on slicer selection like top 5 ,10,15,20,.....like that.

       

       

       

      here rank result is coming as expected if i change any selection on year slicer.

      thanks for your  support..

       

      I am going to  apply the top 5 10 15 slicer  if any issues  i will come back to you ...