Forum Discussion

arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

Rank for particular years

hi i need to show the rank of the countries for praticular years   my expreession for rank is   Rank = RANKX(ALL('table'[Country]),[Sum_value],,0)   i am getting rank for the countries   my n...
General Comment
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi

 

  It might the same number of rows for both the Year. 

 

 In the below screenshot, if you take the Rank_dimension, it has the same number of values because it has same 4 entries. In case if you have a different number of rows then you will get different values.

 

 To show that, I created another 2 column 2012Yr & 2013Yr with RankYear column and it shows 4 & 8 values.

 

 

arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

This is the output i am getting

 

 

can you see china has different values for 2016 and 2017 but getting same rank

 

can you help me on this

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi arulsettu,

     

    Please sort your data by year, the different value with same rank mean they have same rank in different category.

     

    Regards,

    Xiaoxin Sheng