Rank replication issue to be distinct and not repeated

[Anonymous]

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?

[Anonymous]

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.

[amitchandak · Accepted solution]

@Anonymous , You need to consider breaking a tie for rank.

Refer if this can help

https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-...