Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove Duplicate Ranking

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])))
 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

     

15 Replies