Issue working with RankX

[Anonymous]

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. 

[Anonymous · Accepted solution]

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