Rankx : work if "expression" is a measure but not with direct calculation ?

[Arkhos94]

I have a basic table "aftersales" like this :

Dealer	Sales
A	1000
B	3000
C	2000
D	1700
E	5000

I want to tank them.

If I do it creating two measure it works :

measure 1 : sales_amount = sum('aftersales'[Sales])

measure 2 : ranking = rankx(all('aftersales'[Dealer],[sales_amount])

But If I try to put it all in 1 measure, it fails (everyone get ranked 1)

measure 3 : ranking = rankx(all('aftersales'[Dealer],sum('aftersales'[Sales]))

Can someone help me understand why ?

[Arkhos94]

thanks @SanketBhagwat and @Jihwan_Kim  for your help

It did not work by removing the sum but it worked by adding a calculate before the sum

[SanketBhagwat]

Hi @Arkhos94 .

You don't need to use 'sum' in here;

ranking = rankx(all('aftersales'[Dealer],sum('aftersales'[Sales])).

Remove 'sum' function and try it.

If this helps you, then please mark it as 'Accept as Solution' so that others could find it easily and give it a big thumbs up.

Regards,

Sanket Bhagwat

[Jihwan_Kim · Accepted solution]

measure 3 :

ranking =
RANKX (
ALL ( 'aftersales'[Dealer] ),
CALCULATE ( SUM ( 'aftersales'[Sales] ) )
)