Forum Discussion
Getting the RANK for Top N without duplicates
Hello everyone, I have a Table visualization below. I need a help to create the Rank in order for the STP % even if the STP is same [for eg; the very first few records showing 100% and wou...
Hi,
While i have been able to get different rank values, the numbers/order is not correct. This may serve as a starting point for you. You may download my PBI file from here.
Hope this helps.
Hi Anonymous,
Perhaps you can add a category field to the expression to ranking based on multiple columns, they should help reduce the duplicate rankings: (these rankings will be based on the category and values)
RANKX on multiple columns with DAX and Power BI - SQLBI
You can also refer to the following link about rankx function if helps:
Introducing RANKX in DAX - SQLBI
Regards,
Xiaoxin Sheng