Filter on multiple column

[ronaldbalza2023]

Hi everyone, how can I apply one filter on multiple columns. Like I wanted to filter out columns having with same zero values. However, if there's non-zero value in it, it will not be applied. As seen on the photo below, circle with red should be filtered out, where highlighted yellow will remain as there's 2.18 value on staff actual hours column. Thanks in advance. 

Staff Estimated Hours  = 
CALCULATE (
    SUM ( 'Jobs/Tasks/Staff Hours'[Assigned Staff Allocated Hours Array OPEN] )
) + [Staff Estimated Hours Not in Array Open] + [Staff NO Estimated Hours Open] + 0

Staff Actual Hours = 
CALCULATE (
    SUM ( Timesheets[Billable Hours] ),
    FILTER ( 'Tasks', 'Tasks'[Task Completed (Job Completed Check)] = FALSE ),
    ALLSELECTED ( 'Date'[Date] )
) + 0

Staff Estimated V Actual Hours = 
IF (
    [Staff Estimated Hours Open Old Measure] = 0,
    0,
    [Staff Estimated Hours Open Old Measure] - [Staff Hours Chargable Timesheets ALL OPEN]
)

[Ashish_Mathur]

Hi,

In the Filter pane, apply a condition on this measure - "Staff estimated v actual hours" as >0.

[ronaldbalza2023]

Hi Ashish, thanks for taking the time on this. Your solution somewhat solve my problem, however, how can I include the rows having negative values? Thanks so much!

[Ashish_Mathur · Accepted solution]

You are welcome.  Change the criteria to Not equal to 0 to factor in both positive and negative values.

[ronaldbalza2023]

Apologies, may I know which one is it here? I used the is not 0 then negatives were gone. Thanks!

[Ashish_Mathur]

Is not 0 should have worked.  I cannot say why it is not.  I may need to see your PBI file.