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

 

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