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" ?

  • Anonymous , not very clear

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

1 Reply

  • Anonymous , not very clear

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