Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

RANKX returns duplicates

Hi all,   i've searched this forum endlessly, but somehow i can't figure out how to resolve this problem. I have a table with problem causes (Aanleiding in Dutch) and i want to show only the TOP 5...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Stachu,

 

i've removed the TOP N filter as you said and added the TOP5 to the filtering using <=5. But unfortunately it still shows the same 6 items :mansad:

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

If you only want to show Top5 with only 5 values

Modified the formula as below

Measure 2 = IF(HASONEVALUE(Sheet1[as]),RANKX(ALLSELECTED(Sheet1),[Measure],,DESC))

create an index column from 1 in the query editor, then add [Index] column to the Visual Filter container and apply "is less than or equal to 5"

 

Best Regards

Maggie