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 o...
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 ) )

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 ) )