RankX return many 1s

[Anonymous]

Hello all,

Iam trying to rank the customerNumber based on the sales. Top sales as 1 and next as 2 and so on .. But I get lot of rank values as 1. 

This is how I am getting.

CustomerNumber	CustomerName	Sales$	Rank
16290	A	430234	1
3874	B	428866	1
16364	C	364207	1
14920	D	364207	1

I am expecting something like below.

CustomerNumber	CustomerName	Sales$	Rank
16290	A	430234	1
3874	B	428866	2
16364	C	364207	3
14920	D	364207	4

I used this : 

Rank = RANKX(ALL('DC-R Ace'[CustomerNumber]),CALCULATE(SUM('DC-R Ace'[EachesCost])),,DESC)

Where am I doing wrong. Please help.

Thanks

[AnkitBI · Accepted solution]

For your case, Use below

Rank = RANKX(ALL('DC-R Ace'[CustomerNumber],'DC-R Ace'[CustomerName]),CALCULATE(SUM('DC-R Ace'[Sales$])),,DESC)

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

[Anonymous]

@AnkitBI  Thanks a ton for the help.
I ve realized that We are supposed to add all the columns to the DAX formula that we are adding on to the visual. 

[AnkitBI]

In your fromual what is [EachesCost] ?

[Anonymous]

Sorry for the inclmplete data..
DC-R Ace is the table,
[Eachescost] is the Sales$ column.