Forum Discussion
Using the "in" operator inside Measure
Hello, I've already used the "in" operator succesfully inside calculated tables. But when I try to use the same syntax inside a measure, than it does not seem to work: NewMeasure =
var...
My apologies, the code I have given does work .... but after some nights sleep, I finally noticed now that I had overlooked that a linkage between two tables is affecting my results. So nothing wrong with the code itself
Thank you all,
Stefan
Anonymous
You can use CONTAINS on a calculate column and then add this column to a measure:
New Column = IF (CONTAINS([Content],"SHOWS"),"SHOWS",IF ([Content] IN {"DRY","WATER"},"DRY","HC"))