Ranking on a value (calculated measure) which has values in percentage

[Anonymous]

hi all,

@v-shex-msft 

my .pbix file link is below. please help to achieve the correct Ranking.

want to calculate RANK for calculated measure "% Change Dollar Price" ( view this measure in pbix )

i tried with below formula but its showing wrong result: 

RANKC = 
RANKX(
    'Big Mac Index',
    'Big Mac Index'[% Change Dollar Price]
)

my wrong results:

correct results:

Link to my pbix file 

regards

[Jihwan_Kim]

RANKC =

RANKX(

ALLSELECTED(BMICountries[Country]),

[% Change Dollar Price]

)

[Anonymous]

@Jihwan_Kim  thanks for quick response

but its not working as it should be. it is showing ranking 1 to 5 for selected countries.

please check my 2nd screenshot where it shows what result is expected. calculating Rank for all countries, and some countries has null values in " % Change Dollar Price " 

hope it clear.

regards

[Jihwan_Kim · Accepted solution]

RANKC =
RANKX (
FILTER ( ALL ( BMICountries[Country] ), [% Change Dollar Price] <> BLANK () ),
[% Change Dollar Price]
)

[Anonymous]

perfect man @Jihwan_Kim 

its working fine, thank you for great help.

regards