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
arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

i created like the image you posted 

 

Rank_dimension = RANKX(ALL('table'[Country]),'table'[Country])

 

iam getting the different ranks. upto this fine

 

now i need the rank for 2 years

 

example 2016 and 2012

 

2012_rank = CALCULATE(SUM([Rank_dimension]),FILTER('table','table'[Year]=2012))

 

2016_rank = CALCULATE(SUM([Rank_dimension]),FILTER('table','table'[Year]=2016))

 

 i am getting same rank for both years

 

can you suggest me how to approach this issue

 

thanks

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

    Thanks for the reply

     

    but i have different values for 2012 and 2016

     

    even getting same rank

     

    can you please explain how its defininig the rank

     

    Rankx(All(table[country],table[copuntry]))

     

    here we are not passing any values right. how its bringing the rank

     

    and why i am getting same rank

     

    Thanks

  • 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