What function to use to leave out service orders that contain a specific task?

[GunnerJ]

I need to disregard any Service Order number that contains the task "WAITFORINS". All of my data is currently within one table and I have custom columns calculating the time the tasks took. Any service order that contains the specific task though is errant and needs to be ignored. 

Each Service Order has multiple tasks so what function(s) can I use to ignore those service orders? It can't just be as simple as "TASK <> "WAITFORINS" as that just gets rid of those specific rows when I need to get rid of all rows of the same Service Order number. 

Thanks

[parry2k · Accepted solution]

@GunnerJ there are many ways to do this, one way is to add a new column using following DAX to see if there is Task with WAITFORINS, and after that filter that service whereever that WAITFORINS = 1

to add new column

Is Wait Service = 
VAR __isWait = 
CALCULATE(
    COUNTROWS( Table ),
    ALLEXCEPT( Table , Table [Service] ),
    Table [Task] = "WAITFORINS"
)
RETURN
IF( __isWait > 0, 1, 0 )

Now for any calculation, let's assume you have qty to sum up where service doesn't have task with WAITFORINS

Total Qty = 
CALCULATE(
SUM( Table[Qty] ),
Table[Is Wait Service] = 0 
)

[Iamnvt]

you can try this measure:

Time Measure = 
  VAR
__temptable = FILTER(
            ADDCOLUMNS (
                VALUES ( 'Table'[Service Order number] ),
                "CombinedTask", SEARCH("WAITFORINS", CONCATENATEX (
                    CALCULATETABLE (
                        VALUES ( 'Table'[TASK] ),
                        'Table'[Service Order number] = EARLIER ( 'Table'[Service Order number] )
                    ),
                    'Table'[TASK],
                    ","
                ),,0)
            ), [CombinedTask] = 0)
RETURN
CALCULATE(SUM('Table'[Time]), __temptable)

here is PBI file:

https://1drv.ms/u/s!Aps8poidQa5zk6shmJTnqUOhqnMT2Q