Getting the RANK for Top N without duplicates

[Anonymous]

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 would like to have Rank as 1 and 2 and go on].

Thanks in advance.

[Ashish_Mathur]

Hi,

I can try to help.  Share the download link of your PBI file. 

[Anonymous]

Hi Ashih, 

Here is the download link.

https://1drv.ms/u/s!Ag3NrywK0UV9dqNx5Nyzkke8B-U?e=A1Qoiz

[Ashish_Mathur · Accepted solution]

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.

[v-shex-msft]

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