top/ buttom n buttom does not eliminate dimension values that are not in it

[aheavy95]

Hi all 

In this bar chart, I added a dynamic top/btm N  input box for the users.

 

In the expression, I have set it to be <= than the top N. My problem is that it still shows the dimension values which dont meet the top n criteria, although the "include nulls" checkbox is unchecked. I have tried adding a "null() " to the expression and that hasn't worked as well.

How can this be solved?

measure:

If(vTopORBottom = 1,
If(Rank(sum(TotalQty_Tran))<=$(vTopN),sum(TotalQty_Tran))
,
If(vTopORBottom = 2,
If(Rank(-sum(TotalQty_Tran))<=$(vTopN),sum(TotalQty_Tran))
))

Thanks

[Rohan]

Hi,

have you tried using the limit within the dimensions ? Refer below image :

Try this part once, instead of using rank in the measure.

Regards,

Rohan.