Removing expression from straight table

[khaycock]

I'm trying to remove an all fields from a straight table for when the quantity is 0.

The expression for Quantity is: sum([Vehicle Rev Qty])

The only way I know how to usually remove them is by ticking 'Suppress Zero Values', but that isnt doing anything in this occasion.

Any ideas on the best way to do it?

[MK_QSL]

May be try below one

sum({<YourDimensionName = {"=SUM([Vehicle Rev Qty])>0"}>}[Vehicle Rev Qty])

[sunny_talwar · Accepted solution]

Do you have more than one expressions? May be you need to force the other values in this row to be null or 0 also. Let Say you have another expression as Count(Measure)... you can do like this

If(Sum([Vehicle Rev Qty]) > 0, Count(Measure))

Repeat this for all your expresisons... and then 'Suppress Zero Value' should work

[krishnacbe]

Hi,

1. Uncheck "Show All Values" Check box if it is checked for any of the Dimensions.

2. Uncheck the Suppress Zero-Values

If you still see the values, share the app or image.

[satheshreddy]

Hi,

Can you try to show Conditionally, like

if(Quantity>=1,1,0)

Regards

Sathish

[khaycock]

This works great thanks Sunny! Is there a way I can get it to only show results when the quantity is above 0? As its given me some negative results that I dont need

[sunny_talwar]

That is strange because I was looking for only quantities above 0

If(Sum([Vehicle Rev Qty]) > 0, Count(Measure))

Did you check with <> may be?