Solved: Getting the RANK for Top N without duplicates

Anonymous · ‎10-13-2022

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 · ‎10-14-2022

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Ashish_Mathur · ‎10-13-2022

Hi,

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎10-13-2022

Hi Ashih,

Here is the download link.

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

Ashish_Mathur · ‎10-14-2022

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎10-13-2022

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