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
Sohail
Advocate IV
Advocate IV

Subcategory Ranking

Hi All,

 

I have an interesting scenario were I have to Rank Team members based on Team. Below is just an example.

Please help. Thank you!

 

TeamsAgentsScoreRank
Team 1Agent 8961
Team 1Agent 6402
Team 1Agent 5153
Team 1Agent 18124
Team 2Agent 6781
Team 2Agent 7781
Team 2Agent 4692
Team 2Agent 18173
Team 3Agent 131001
Team 3Agent 20623
Team 3Agent 3782
Team 4Agent 171191
Team 4Agent 15792
Team 4Agent 2523
Team 4Agent 16464
Team 5Agent 7901
Team 5Agent 6792
Team 5Agent 1773
Team 5Agent 17554
Team 5Agent 14435
Team 5Agent 12106

 

Regards

Sohail

1 ACCEPTED SOLUTION
sokg
Solution Supplier
Solution Supplier

Hi @Sohail

 

you must create a new column and write

 

Rank = RANKX(FILTER(Table1;Table1[Teams]=EARLIER(Table1[Teams]));Table1[Score];;;Dense)

 

and the result is :

 

Capture.JPG

View solution in original post

2 REPLIES 2
sokg
Solution Supplier
Solution Supplier

Hi @Sohail

 

you must create a new column and write

 

Rank = RANKX(FILTER(Table1;Table1[Teams]=EARLIER(Table1[Teams]));Table1[Score];;;Dense)

 

and the result is :

 

Capture.JPG

@sokg 

 

Thank you It's working wondeful.

 

Regards

Sohail

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.