Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Comparing Strings

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's avatar
    4 years ago

    Anonymous , not very clear

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