Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
krishnachaitany
Frequent Visitor

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

 

 

Rankx issue 1.pngRankx issue 2.png

1 REPLY 1
krishnachaitany
Frequent Visitor

Dax function for reference :-

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.