Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ramutd54
Frequent Visitor

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 hhere my rank should start from 1 to 48 hPlese help me  how to get the desired ranks...

4 REPLIES 4
Zubair_Muhammad
Community Champion
Community Champion

Hi @ramutd54

 

Try adding the SORTOrder parameter

 

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

Regards
Zubair

Please try my custom visuals

 

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 datesI am geting 1 for all dates

Hi @ramutd54

 

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

 

Could you share your file?

 

Give this a try

 

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

 

 


Regards
Zubair

Please try my custom visuals

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.

 

 

 

rank_issue3.JPGhere  rank result is coming as  expected if i change any  selection  on year slicer.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 ...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.