Top N + Others - Using RANK

[Anonymous]

Dears,

I have one table where i need to create a Top N + Others using two collumns, there is a Project and a Cost collum. i´ve create a rank using this two values and now i want to create a measure using IF parameter to create get the first 20 itens in the Rank measure as 'Top N' and all other as 'Others'

To do that i am using the following code :

Group2 = IF([rank]<=20,"TopN","Others")

But when i try to run this measure i get an error as image below

I modified the command just to check if the error disapear, when i replaced 20 to 20,0, the error gone.


But using 20,0 i cant get what is TopN and what is others, all the values will be considered as Others.

After that, if i can get the TopN and Other, i will apply a What If Parameters