Rankx is not working properly for me

[Anonymous]

Hello all. I have the following table and trying to rank the regions according to the ECI column. As you see can see, the ranking shows weird results. Additionally, I have a date filter, which rankings must change according to the yearly values. I have tried this formula:

Rank =

RANKX (

ALL ( 'eci_all_kz (2)'[final_eci], 'eci_all_kz (2)'[Date]),

CALCULATE ( SUM ( 'eci_all_kz (2)'[final_eci]) ),,DESC

)

Can you please help to solve the issue?

@amitchandak 

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download example PBIX file

You need to pass in the Region column inside ALL() not the final_eci column.

Use this to create a measure

Rank = RANKX ( ALL ('eci_all_kz (2)'[Region]), CALCULATE ( SUM ( 'eci_all_kz (2)'[final_eci]) ) ,,,dense)

or a column

Ranks = RANKX (  'eci_all_kz (2)', [final_eci] )

I don't understand what you mean by this Additionally, I have a date filter, which rankings must change according to the yearly values  - please give an example. 

You need to explain what you mean by that and also show the dates you have in the eci_all_kz (2)'[Date] column

Regards

Phil