RankX not working when you add client description

[lnpapin]

HI,

I have this test data: Test data

When I write this mesure i get this result which is perfect:

Formula + result table

But when i whant to add the name (Nom in french) of the client i get this result with all 1 instead of the right  rank

Adding sub cat

I have been trying lots of differents way of writting this formula base on related question in this forum but i always get the same kind of result: 

Other war of writing formula

Can someone help me please?

[camargos88]

Hi @lnpapin ,

Try changing the measure code, instead of Cliente inside the ALLSELECTED write just the table name:

RANKX(ALLSELECTED('Table'); CALCULATE(SUM('Table'[Value])))

Ricardo

[lnpapin]

Thanks @camargos88  for the quick reply

I have try your solution but i get this weird result:

ClientNomProduitValeur

A	AA	XYZ	20
B	BB	MNO	30
C	CC	XYZ	50
D	DD	MNO	50
E	EE	MNO	75
A	AA	MNO	50
B	BB	XYZ	25
C	CC	MNO	10
A	AA	RST	15

[camargos88]

@lnpapin ,

Are you filtering something else ?

Is it a measure, right ?

Ricardo

[lnpapin]

no i only have that table in my pbix, and yes i did it as a mesureX

[camargos88]

@lnpapin ,

Can you share you pbix ?

Ricardo

[lnpapin]

I'm sorry but i cant seems to find how to atch my pbix in the forum can you share me your e-mail

[camargos88]

@lnpapin ,

Just change the aggregation of Valeur column:

Ricardo

[lnpapin]

OK and if i want to see the rank of the total value how can i do that?

[camargos88 · Accepted solution]

@lnpapin ,

Try this measure:

RANK1 = RANKX(ALLSELECTED('Table'[Client]; 'Table'[Nom]); CALCULATE(SUM('Table'[Valeur])))

[lnpapin]

Thanks you so much! it works

[camargos88]

@lnpapin ,

You can use onedrive/google drive/dropbox.

Ricardo

[lnpapin]

https://1drv.ms/u/s!AhHPy19bUAy6kFK0EPcTMthfZ__8