topic Re: Double number in a top application with RANKX Formula in DAX Commands and Tips

Double number in a top application with RANKX Formula

Anonymous — Tue, 20 Dec 2022 17:13:32 GMT

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,

Re: Double number in a top application with RANKX Formula

FreemanZ — Tue, 20 Dec 2022 21:37:19 GMT

hi Anonymous

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/

Re: Double number in a top application with RANKX Formula

Anonymous — Thu, 22 Dec 2022 10:49:46 GMT

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,

Re: Double number in a top application with RANKX Formula

FreemanZ — Thu, 22 Dec 2022 12:23:44 GMT

how is this measure defined?

Re: Double number in a top application with RANKX Formula

Anonymous — Thu, 22 Dec 2022 14:26:09 GMT

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,

Re: Double number in a top application with RANKX Formula

Anonymous — Fri, 23 Dec 2022 08:18:11 GMT

FreemanZ