Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table that has a rank that appears to be distinct as shown below.
Name | Rank | New Rank |
Lil | 1 | 1 |
Joe | 1 | 2 |
Bill | 1 | 3 |
Anne | 4 | 4 |
Chris | 5 | 5 |
I hope to achieve the New Rank as shown in the table using DAX. How is this possible?
Solved! Go to Solution.
@Datagulf , You need to consider breaking a tie for rank.
Refer if this can help
Hey @amitchandak , this does not work for a table visual, however. It only works for tables in the Data view of the Power BI desktop. Could you have a solution. Probably a Measure that does not take accounts of ties and returns a continuous rank even if it will break the ties using alphabetical order.
@Datagulf , You need to consider breaking a tie for rank.
Refer if this can help
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |