Forum Discussion
Double number in a top application with RANKX Formula
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
5 Replies
- FreemanZ
Super User
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
- AnonymousNot applicable
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
Super User
how is this measure defined?