Forum Discussion
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] + 0Staff Actual Hours =
CALCULATE (
SUM ( Timesheets[Billable Hours] ),
FILTER ( 'Tasks', 'Tasks'[Task Completed (Job Completed Check)] = FALSE ),
ALLSELECTED ( 'Date'[Date] )
) + 0Staff 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]
)You are welcome. Change the criteria to Not equal to 0 to factor in both positive and negative values.
5 Replies
- Ashish_MathurSuper User
Hi,
In the Filter pane, apply a condition on this measure - "Staff estimated v actual hours" as >0.
- ronaldbalza2023Continued 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_MathurSuper User
You are welcome. Change the criteria to Not equal to 0 to factor in both positive and negative values.