How to get distinct rank based on duplicate value

[mohittimpus]

I have 2 Tables:

1) Date

2) Employee_Info

'Date' master table is connected with Employee_Info.

I have created one table visualization inside Employe_Info.pbix file. Table is filter with Year.

1) Inside Employee_Info.pbix "Fiscal Month" is taking from Date table, after that I created one Measure with name "#Count Employee" which calculate total 'Count of Employee' column.

#Count Employee = CALCULATE(SUM(Employee_Info[Count of Employee]))

2) After that I created  Measure with name "Rank of Employee" Which is getting rank of Employee based on fiscal Month.
Rank of Employee = RANKX (FILTER(ALLSELECTED('Date'[Fiscal Month])), [#Count Employee],,ASC,Dense))

*I need Distinct rank based on duplicate value. Below image I have updated Rank of Employee with Red Text for Required Rank.

* I need Distinct rank based on duplicate value. Below I have shared Link for .Pbix file.
https://www.dropbox.com/s/rs37k7y48bk827u/Employe_Info.pbix?dl=0

[v-xicai · Accepted solution]

Hi @mohittimpus ,

You may just change the Dense to Skip in your formula. You can learn more about RANKX function here https://docs.microsoft.com/en-us/dax/rankx-function-dax.

Rank of Employee = RANKX (FILTER(ALLSELECTED('Date'[Fiscal Month])), [#Count Employee],,ASC, Skip))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@mohittimpus read this post which talks about breaking the ties (end of the post)

[mohittimpus]

Hi.. @parry2k 
Thanks.. for Reply

It is not working.... 

[parry2k]

@mohittimpus not sure if your reply is helpful. better would be if you explain what you tried, and what result you are getting?