Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Remove Duplicate Ranking

‎06-10-2020 03:43 AM

Dear All,

I want unique ranking for all records having same values in column.

As shown in below image, 2 users having same amount so ranking is same 8, 8 for both but I want 8 and then 9 for other user.

How can I do it. Kindly help me.

rank example = RANKX(ALLSELECTED(Farmer_Transactions[RetailerCode]), CALCULATE(SUM(Farmer_Transactions[Quantity])))
 
bi.png
Labels:
Message 1 of 16
6,984 Views
0
1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion
In response to Anonymous

‎06-15-2020 08:26 PM

HI @Anonymous ,

 

The last 2 Sales Person have the same amount of Sales and that is why it is showingin the TOP 10 employees by Sales.

 

Incase you want to show 10 employees, you will need to break the ranks ( but this will not give a clear picture to the person whom you are sharing this dashboard) as both Rajesh and Rishant has 97 units of Sales.

 

 

Anyways incase you want to break ties.

 

Create a new measure

 

Randome = RAND()
 
 
Add [Randome] to Rank Measure
 
Rank Employee =
var a = RANKX(ALL(Sheet1[RetailerName]),[Quantity Sold per Employee]) + [Randome]
RETURN
a
 
1.jpg
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

 

View solution in original post

Message 15 of 16
6,905 Views
15 REPLIES 15

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

View All