Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
How can i get rank without repetitive rank for the same values? As you can see in my example it really messes up my cumulative values:
Ranking is based on totalestimatedValue which is a custom measure.
Hi @IvanMislav,
What would like to get? Same values have two ranks? That's not right. So what do you expected?
Best Regards,
Dale
I would like to know if there is a way to work around this problem. It is impossible to make an accurate Pareto analysis with this kind of ranking. I found a couple of workarounds in other posts but none of those seemed to work in my case.
I guess this could be solved with some DAX magic but I'm not sure how to do that.
Hi @IvanMislav,
Can you share the file? Will it solve the issue that only use one rank a time? For instance, 6 6 to 6, 7.
Best Regards,
Dale
Sorry, can't share the file beacuse the data is sensitive, but yes, only one rank a time would solve the problem. Do you know how to do that?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
84 | |
66 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |