Remove Duplicate Ranking

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

 

 

 

Regards,
Harsh Nathani

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