Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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!
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
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,
HN
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
Hi @Anonymous ,
Can you pls upload it on Google Drive.
Not able to access this file.
Regards,
Harsh Nathani
Hi @harshnathani ,
Kindly download pbix from below link -
https://drive.google.com/file/d/1sfAMtEoMXSvZrKLQTOiL266_EDWB9l0B/view?usp=sharing
Hi @Anonymous ,
You need to provide access to the file.
Regards,
HN
Hi @harshnathani , sorry for the botheration you faced.
Access is granted to you..Kindly let me know in case of any isssue
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)
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 -
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
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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 🙂 🙂
@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
Hi @Anonymous ,
Just check my blog on handling duplicate rankings here:
This should help you.
Thanks,
Pragati
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
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |