Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 vSelection=calculatetable(selectcolumns('table1', "Selection",[items])) return calculate(max(table2[Score]),filter(all(table2),table2[item] in vSelection))
Solved! Go to Solution.
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
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"))
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |