Forum Discussion

krishnachaitany's avatar
krishnachaitany
Frequent Visitor
3 years ago

Rankx Dense issue.

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

 

 

Need Help

1 Reply

  • krishnachaitany's avatar
    krishnachaitany
    Frequent Visitor
    3 years ago

    Dax function for reference :-

    Rankx Country =
    RANKX(
        ALL('Infant Mortality_Fact'[Name],'Infant Mortality_Fact'[Ranking]),[Mortality Rate],,DESC,Dense)