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 ...
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)

     
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dear Harsh,

Thanks for your help.

Just I have only query. May be it is my silly question and may be not possible..but please clear my doubt.

As you shown in the chart, it is showing 11 retailers data as they are falling in below 11 rank.

but can I show only top 10 retailers as shown in below chart -

Anonymous's avatar
Anonymous
Not applicable
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)

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you so much Harsh providing me the solution that I required.

    But yes, you are right... my supervisor also saying the same thing that let the 11th person come in the dashboard because he also sold the same quantity as 10th one.

    I am using your solution.. Thanks a lot to all 🙂 🙂