Display only above 0 values in bar chart.

[#1]

I have a requirement where I need to display bottom 10 suppliers by the certain calculated measure. Added condition is that, those bottom 10 values should be above 0 values.

I have tried putting an IF condition in the measure, and dimension is bottom ordered and a limitation of 10. However this is not working.

[sunny_talwar]

May be this:

Sum({<Suppliers = {"=Sum(Sales) > 0"}>}Sales)

and then may be use the dimension limits tab to show the bottom 10 suppliers