Comparing Strings

[Anonymous]

how can I make a measure to calculate  sum of column one<stop time> per each machine if the colomn two <machine name> is not "Option 1 " or "Option 2" ?

[amitchandak · Accepted solution]

@Anonymous , not very clear

calculate(sum(Table[Column1]), filter(Table , not Table[Column2] in {"Option1", "Option2"} ) )