9 Replies Latest reply on Mar 2, 2016 12:11 PM by Rody Zakovich

# Exclude Zero

how to exclude zero, if entire row contains zero , that multiple measures(containing dynamic measure names in report) in report.

• ###### 1. Re: Exclude Zero

Hi Raghu

You'd just use the filter, set it to not equal to 0.

You maybe able to do that on a single field, or you may have to do multiple, it depends on your data/ setup.

The other option is to create a calculated field

IF SUM([your field])=0 THEN 'hide' ELSE 'show' end

Set on the filter tab as Show.

Cheers

Mark

1 of 1 people found this helpful
• ###### 2. Re: Exclude Zero

Hi,

Please post a sample workbook . it will be easy for looking at the issue.

• ###### 3. Re: Exclude Zero

Hello Raghu,

If possible share your sample workbook or screen shots.

Regards

Jaideep

• ###### 4. Re: Exclude Zero

If you want to show values of 1 or greater, take the measure that contains the zero, drag it to the filters window.  Set the filter to be 'At Least' with a value of 1.

If you want to show values of 0.0001 or even more decimals, just change this to whatever values you want to be displayed.

• ###### 5. Re: Exclude Zero

example:

if you include measure name, the marked zero line may have non zero value.

• ###### 6. Re: Exclude Zero

Hi

can u share the workbook . so that we can look at the issue.

• ###### 7. Re: Exclude Zero

Tharashasank Davuluru wrote:

Hi

can u share the workbook . so that we can look at the issue.

Check this thread > Exclude zero if entire row is zero

• ###### 8. Re: Exclude Zero

Here I created a cal field (sum of 4 measures) and dragged it to  filter and set the least value to 1.

If you need to add other measures add them to the cal

find the attached workbook, hope this helps

• ###### 9. Re: Exclude Zero

Don't mean to be rude here, but given the Image above, I think the best solution would be Excel.....

There is possibly a way to get you to a solution, but it's not going to be pretty. Tableau just wasn't necessarily built to be used like Excel, so things like this have limitations.

Regards,

Rody