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
CourtneyB
Frequent Visitor

RANKX Help!

Hi Everyone,

 

I am hoping someone can help me becausebecause this RANKX is really giving me a run for my money. I am fairly new to Power Bi and have been teaching myself as I go and I have hit a wall with this one. I need to rank different companies average turn times (i.e. how long it took them to deliver the product from start to finish) from lowest to highest time by state. Any help is much appreciated. 

 

 

 

1 ACCEPTED SOLUTION

Hi All, 

 

So, my boss was able to figure it out. the correct formula to use for my case is the following:

 

Rank = RANKX(ALLSELECTED('2821_410_700_150'[CompanyName]), CALCULATE(AVERAGE('2821_410_700_150'[TT100150_CD])),,ASC,Dense)-1

 

Thank you for all your imput and assistance.

View solution in original post

12 REPLIES 12

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.