Double number in a top application with RANKX Formula

[LD1]

Hi everyone, 

I would like to know something and of course to solve it.

I mean, when I do this RANKX formula, at the beginning all is working. 

But, when I just want to get the top 30, i have some double figures in the rank formula. 

I don't know why. 

Here it is an exemple : 

1. Without the top 30 application :

2. With the top 30 application : 

Can you help me please to solve it? 

Thank you in advance, 

LD

[FreemanZ]

hi @LD1 

it seems you have ties and RANKX has its 5th argument for such case. 

try like

RANKX(ALL(), [], , , DENSE)

https://learn.microsoft.com/en-us/dax/rankx-function-dax

https://dax.guide/rankx/

[LD1]

Hi @FreemanZ 

I tried with your explication but it still doesn't work when I apply the top 30 in the field RANG:

Double value is still here ... 

I really want to understand why it doesn't work. The problem can be provided about the formula 'Groupe ou marque annonceur'? Here this is the formula :

Thank in advance for your help, 

LD

[FreemanZ]

how is this measure defined?

[LD1]

It's turn over value the sum of 3 values in KPI Table

One comes from the dataset, 

+ on other comes from Excel source

+ the last one too

Can it be the format ? (Decimal, Devise, etc.)

Thank you so much, 

[LD1]

@FreemanZ