Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter a value above a threshold

Hi Everyone

 

I have two columns, one status and one duration. The status column has 6 possible text outcomes and I need to filter the duration column to ignore anything above 4hrs., but only for one of the statuses.

 

Not sure how I do this? 

 

I have been unsuccessfully trying to calculate the values using a filter. 

 

anyideas?

Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    So you should be able to do this with something like the following:

     

    = CALCULATE( SUM( table1[Duration]
       , Filter( table1, table1[Status] <> "Status1" ||  (table1[Status] = "Status1" && table1[Duration] <= 4 ) )

1 Reply

  • d_gosbell's avatar
    d_gosbell
    Super User
    7 years ago

    So you should be able to do this with something like the following:

     

    = CALCULATE( SUM( table1[Duration]
       , Filter( table1, table1[Status] <> "Status1" ||  (table1[Status] = "Status1" && table1[Duration] <= 4 ) )