RANKX FUNCTION ISSUE

[Anonymous]

Hi, how are u? I am new in the community. I was creating a RANKX function i was having trouble wih it.

I have the table below:

Cliente is an unique identifier for a customer and "CuitsConsultadosUnicos" is the number of times that customer enter to a website.

I want to create a rank of the customer that enter to the website. Im expecting the next result

RANK    CLIENTE           SUM(CuitsConsultadosUnicos)

1                 *                  44

2             30709584193  2

But instead of that i get 

RANK    CLIENTE           SUM(CuitsConsultadosUnicos)

1                 *                  44

5            30709584193   2

Here are the measure that ive used to create the rank:

Q_CUITS_CONSULTADOS_U =
SUM(Piloto[CuitsConsultadosUnicos]),

RANKING_CLIENTE =
RANKX(
ALL(Piloto),
[Q_CUITS_CONSULTADOS_U]
)

Thank you so much!

[amitchandak · Accepted solution]

@Anonymous , try like

RANKING_CLIENTE =
RANKX(
ALL(Piloto[CLIENTE]),
[Q_CUITS_CONSULTADOS_U]
)

or

RANKING_CLIENTE =
RANKX(
allselecetd(Piloto[CLIENTE]),
[Q_CUITS_CONSULTADOS_U]
)