How to use DAX Filter using IN with String Parameter ?

Hi All,

I want to add a custom column to a table B with certain calculation to get the maximum value on a product from another table A, however each event_venue_id in the table B might have different products mapping.

This is the source table A for calculation (i created a column called productid_string with datatype Text) :

I've prepared the list of products mapping for each event_venue_id, by adding column productidlist in table B like this :

the result in table B (column productidlist)

Then I create the custom column in table B (ITR M-3) to get maximum value of product like this.

When I fetched the values into a variable and use it within filter it wont' work using double quotes, then i tried to test manually using unichar(34) and it works.

Can someone help me how to fix the parameter or how to filter using multiple values of product id?

Thank You