Help me about RANKX

neonguyen1803 — Thu, 06 Jul 2023 04:27:22 GMT

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()

Re: Help me about RANKX

Jihwan_Kim — Thu, 06 Jul 2023 05:34:22 GMT

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.

topic Help me about RANKX in DAX Commands and Tips

Help me about RANKX

Re: Help me about RANKX