Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear all,
I have to create a RankX measure to do ranking about dept of customers. But when i wrote:
RANKX = RANKX(ALL('AR by KH'[Customer]),SUM('AR by KH'[Dept]), , DESC)
It's not working, each row gets a result is 1
But when I change my code to:
RANKX = RANKX(ALL('AR by KH'[Customer]), CALCULATE(SUM('AR by KH'[Dept])), , DESC)
It's working for this sentence
So my question is: CALCULATE(SUM('AR by KH'[Dept])) and SUM('AR by KH'[Dept]) what is different? Because as I knew, when using Calculate without filter, the result will be the same with SUM()
Solved! Go to Solution.
Hi,
What CALCULATE does above is transition the row context to the filter context inside the measure.
In above, if the measure,
SUM Measure = SUM('AR by KH'[Dept])
is written first,
and then when you create a RANKX measure like below,
RANKX = RANKX(ALL('AR by KH'[Customer]), [SUM Measure], , DESC)
it will show the expected result.
I hope this helps.
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.
Hi,
What CALCULATE does above is transition the row context to the filter context inside the measure.
In above, if the measure,
SUM Measure = SUM('AR by KH'[Dept])
is written first,
and then when you create a RANKX measure like below,
RANKX = RANKX(ALL('AR by KH'[Customer]), [SUM Measure], , DESC)
it will show the expected result.
I hope this helps.
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 |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |