Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 vSelection=calculatetable(selectcolumns('table1', "Selection",[items]))
return
calculate(max(table2[Score]),filter(all(table2),table2[item] in vSelection))




 

Does anyone have an idea how to solve this? By the way, table2 is a calculated table.
 
Kind regards,
 
Stefan
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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

themistoklis
Community Champion
Community Champion

@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"))
petrovnikitamai
Resolver V
Resolver V

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))

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors