Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I need to rank names based on the amount sold by each person, but I have to consider the group where each person belongs. So my total value for sales must be different depending on which group I´m talking about.
I have this chart and I tried to rank with this formula:
Expected result: to get a rank from 1 to N for EACH group, so it would have 3 people with different amount of sales ranked as number 1, one in each group.
Can you help me please?
Solved! Go to Solution.
@99829497 Here is my solution.. try this..
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you ! Good Luck 👍 |
I tried again but now instead of "sales" I´m using a value that indicates a "saving" (it´s a decimal number that also could be shown as a %). I created the same ranking formula but now it didn´t work. Do you know how I can fix it?
TKS again
@99829497 Here is my solution.. try this..
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you ! Good Luck 👍 |
It worked! Thank you!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |