Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to use DAX filter using IN with String Parameter?

Hello everyone

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

This is source table A for the calculation (I created a column named productid_string with the Text data type):

pbi3.PNG

I have prepared the list of product maps for each event_venue_id, adding the productidlist column in table B as follows:

pbi4.PNG

the result in table B (column productidlist)

pbi2.PNG

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

When I got the values in a variable and use it inside the filter that doesn't work using double quotes, then I tried to test manually using unichar(34) and it works.

pbi.PNG

Can someone help me correct the parameter or how to filter using multiple product ID values?

Thank you

3 Replies