Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |