Forum Discussion
Rank for unique values
Hi Team ,
I need help to rank number to unique values .
Source Data - In below Table i got same rank for unique value as 0 , i want each "0" value showing unique rank .
| Category Name | Calculated Measure (Values) | Rank |
| A | 10 | 1 |
| B | 20 | 2 |
| C | 0 | 3 |
| D | 0 | 3 |
| E | 0 | 3 |
| F | 0 | 3 |
Expected Output - we need below output .
if there is any unique value in calculated column(Values) , i want diffrent rank for each unique value like below .
| Category Name | Calculated Measure (Values) | Rank |
| A | 10 | 1 |
| B | 20 | 2 |
| C | 0 | 3 |
| D | 0 | 4 |
| E | 0 | 5 |
| F | 0 | 6 |
Thank you in advance , kindly help me to solve this issue .
Hi, SAPpowerbi
You can try to add the index column in the power query editor.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, SAPpowerbi
You can try to add the index column in the power query editor.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SAPpowerbi You could use The Mythical DAX Index: (1) The Mythical DAX Index - Microsoft Power BI Community
