Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |