Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue working with RankX

Hello guys, I know this is just another question like many many here and I have tried many answers but RANKX is not working for me right now. 

 

Also tried : 

Airport Rank = RANKX (ALL(StatsByAirPassengers), [Totalpassengers])
Airport Rank = RANKX (ALLSELECTED(StatsByAirPassengers), [Totalpassengers])

I got 4 years of data for Totalpassengers by airport name. 

I am practicing to get rank for airport by #of totalPassengers but it starts from rank 16 and then inscreasing strangely.

 

your help is appreciated. 

 
 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    That was really strange, i removed all Values from table and put it back and RANX calculation worked fine. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    That was really strange, i removed all Values from table and put it back and RANX calculation worked fine.