Filter pivot table if any month value is not zero

[cr731]

I have a table with a column of dates and a column of values, which should all be zero (variances).

When I pivot this and put the dates in the columns, I want to filter the table so that all rows with a variance in any month will remain. But when I use a value filter, it just filters for the summed value of all months, so that if January is -10 and February is +10, it would net to zero and not be captured.

Is there any way to do this, either with basic pivot table functionality or using a calculated measure (DAX)?

Thanks

 

[cr731]

Thanks! I tried both and they work perfectly as expected.

 

[cr731]

I spoke a little too soon.

So I was working with the formula a bit to make it less susceptible to small variances (in other words, if it rounds down to 0, such as .25, I want to hide it). So my formula is,

IF(
   ROUND([Var (Total Hours)],0) = 0,
   BLANK(),
   [Var (Total Hours)]
)

And I get some rows where every value in the columns is blank, but the pivot table is still showing that row. Is there anything I'm doing wrong above that would make this happen?