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
i'm not sure,
in this case vSelection is table
filter "in" works with list of values only
try this
NewMeasure = var vSelection=values(table1[items]) return calculate(max(table2[Score]),filter(all(table2),table2[item] in vSelection))