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

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