Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

PowerBI dax switch for ranking

on

it has 2 parameters, so the user can select rank for sales sum ranking for each country.
but below dax has some problem, some of the rank either appears duplicated, for example, 5,6,6,7,8,9,10, or the rank missed e.g. 5, 6, 7, 9,9,10. though the sales sum has no duplication or missing.

can anyone spot anything wrong? 'topN'[topN] is one of user selected parameter, while bottomN'[bottomN] is another parameter.

thank

TopN CCY =

RETURN SWITCH(TRUE(),

 positions[rank 2] >= SELECTEDVALUE('topN'[topN]) && positions[rank 2] <= SELECTEDVALUE('bottomN'[bottomN]) ,
 [rank 2]

)

Comments

Post a Comment