Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
5 years ago
Solved

Filter on multiple column

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's avatar
    Ashish_Mathur
    5 years ago

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

5 Replies

  • Hi,

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

    • ronaldbalza2023's avatar
      ronaldbalza2023
      Continued Contributor

      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's avatar
        Ashish_Mathur
        Super User

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