Rankx Dense issue.

[krishnachaitany]

Hi Community Memebers,

Greetings of the day!

I am trying work on a Infant Mortality 2016 Dataset in which trying to implement Rankx(Dense).But it isnt working as expected .Could you please help me on this.

For Instance Country 'Burundi & Laos' has same value of Mortality Rate of 37.8 which has to show same rank of 35 but in my case it is showing a different Rank Values for both the cities.

Thanks in advance.

regards

K G K Chaitanya

[krishnachaitany]

Dax function for reference :-

Rankx Country =

RANKX(

    ALL('Infant Mortality_Fact'[Name],'Infant Mortality_Fact'[Ranking]),[Mortality Rate],,DESC,Dense)