Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi all,
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:
regards
Solved! Go to Solution.
RANKC =
RANKX (
FILTER ( ALL ( BMICountries[Country] ), [% Change Dollar Price] <> BLANK () ),
[% Change Dollar Price]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@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
RANKC =
RANKX (
FILTER ( ALL ( BMICountries[Country] ), [% Change Dollar Price] <> BLANK () ),
[% Change Dollar Price]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |