topic Re: Remove Duplicate Ranking in Desktop

Remove Duplicate Ranking

Anonymous — Wed, 10 Jun 2020 10:43:37 GMT

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

Re: Remove Duplicate Ranking

Anonymous — Wed, 10 Jun 2020 10:51:41 GMT

Hi Anonymous ,

https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

This article explains how you can create unique ranks.

Regards,

Harsh Nathani

Re: Remove Duplicate Ranking

Pragati11 — Wed, 10 Jun 2020 10:55:11 GMT

Hi Anonymous ,

Just check my blog on handling duplicate rankings here:

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

This should help you.

Thanks,

Pragati

Re: Remove Duplicate Ranking

amitchandak — Wed, 10 Jun 2020 11:11:09 GMT

Anonymous , refer this to break tie

https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/

https://forum.enterprisedna.co/t/rank-unique-ranking-when-there-are-duplicate-values/2815

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Re: Remove Duplicate Ranking

v-diye-msft — Thu, 11 Jun 2020 02:36:56 GMT

Hi Anonymous

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!

Re: Remove Duplicate Ranking

Anonymous — Fri, 12 Jun 2020 17:22:37 GMT

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 -

or please help me with some other expression

Re: Remove Duplicate Ranking

Anonymous — Fri, 12 Jun 2020 17:31:37 GMT

Hi Anonymous ,

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,

Re: Remove Duplicate Ranking

Anonymous — Fri, 12 Jun 2020 18:19:26 GMT

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

Re: Remove Duplicate Ranking

Anonymous — Sat, 13 Jun 2020 08:40:06 GMT

Hi Anonymous ,

Can you pls upload it on Google Drive.

Not able to access this file.

Regards,

Harsh Nathani

Re: Remove Duplicate Ranking

Anonymous — Mon, 15 Jun 2020 11:10:55 GMT

Hi Anonymous ,

Kindly download pbix from below link -

https://drive.google.com/file/d/1sfAMtEoMXSvZrKLQTOiL266_EDWB9l0B/view?usp=sharing

Re: Remove Duplicate Ranking

Anonymous — Mon, 15 Jun 2020 11:15:48 GMT

Hi Anonymous ,

You need to provide access to the file.

Regards,

Re: Remove Duplicate Ranking

Anonymous — Mon, 15 Jun 2020 11:58:49 GMT

Hi Anonymous , sorry for the botheration you faced.

Access is granted to you..Kindly let me know in case of any isssue

Re: Remove Duplicate Ranking

Anonymous — Mon, 15 Jun 2020 12:56:24 GMT

HI Anonymous .

Please find link to the file

https://drive.google.com/file/d/1ezsx_2BbNpCqkF3dku7aQ0jrLX5sQqVw/view?usp=sharing

Regards,

Harsh Nathani

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

Re: Remove Duplicate Ranking

Anonymous — Mon, 15 Jun 2020 17:38:31 GMT

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 -

Re: Remove Duplicate Ranking

Anonymous — Tue, 16 Jun 2020 03:26:22 GMT

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

Regards,
Harsh Nathani

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

Re: Remove Duplicate Ranking

Anonymous — Tue, 16 Jun 2020 17:50:46 GMT

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 🙂 🙂