RANKX Measure issue

[ramutd54]

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...

[Zubair_Muhammad]

Hi @ramutd54

Try adding the SORTOrder parameter

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

[ramutd54]

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]

Hi @ramutd54

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

Could you share your file?

Give this a try

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

[ramutd54]

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 ...