cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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])))
 
bi.png
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V
Super User V

Re: Remove Duplicate Ranking

HI @bhuprakash ,

 

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

15 REPLIES 15
Highlighted
Super User V
Super User V

Re: Remove Duplicate Ranking

Highlighted
Super User IV
Super User IV

Re: Remove Duplicate Ranking

Hi @bhuprakash ,

 

Just check my blog on handling duplicate rankings here:

https://community.powerbi.com/t5/Community-Blog/Power-BI-Handling-Duplicate-Rankings-Using-the-RANKX...

 

This should help you.

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Highlighted
Community Support
Community Support

Re: Remove Duplicate Ranking

Hi @bhuprakash 

 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Highlighted
Helper IV
Helper IV

Re: Remove Duplicate Ranking

Thank you all for your help and sorry for delayed responce. but still my issue is not resolved....

not able to get top 10 retailers . Below issue is coming -

bi.png

 

or please help me with some other expression

Highlighted
Super User V
Super User V

Re: Remove Duplicate Ranking

Hi @bhuprakash ,

 

Are you creating  Calculated Column or a measure?

And the above formula , is to rank between a group I.e Categories and Subcategories.

 

Can you pls share some sample Data in text format and expected output.

 

And also pls specify measures or Calculated Columns.

 

Regards,

HN

 

 

Highlighted
Helper IV
Helper IV

Re: Remove Duplicate Ranking

Dear Harsh,

 

I am sending you sample data for your reference. 

I have 3 columns Retailer name, Date  and Quantity sold.. I need top 10 reatilers based on their sale quantity and need below output of top 10 retailers-

 

Please download pbix file from here -

https://www.sendspace.com/file/7bgm50

 

bi.png

 

Highlighted
Super User V
Super User V

Re: Remove Duplicate Ranking

Hi @bhuprakash ,

 

Can you pls upload it on Google Drive.

 

Not able to access this file.

 

Regards,

Harsh Nathani

Highlighted
Helper IV
Helper IV

Re: Remove Duplicate Ranking

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors