I discovered that when I have a column with 20 values of which 10 positive and 10 negative and I write a measure asking for the TOPN(15, DESC), I only get the 10 positive values.
Similarly, TOPN(15, ASC) only give the 10 negative values while it should also give the 5 smallest positive values for the function to make sense.
Am I alone in struggling with this? Is it a bug and what is a possible workaround.
Thanks in advance
Tried: TOPN(15, DESC)
Expected: 15 entries instead of the 10 I got
>Solution :
You can use RANKX as a workaround.