Forum Discussion
DAX Contains multiple values from list
Hi! I have table 1 with column which can contain multiple names, and the table 2 with separate names. I'm wondering is there any way to filter the first table if the column with name contains at ...
Thought about it, but real table contain almost 3 millions rows and not only 2 columns. If there is no other way I will create one more table which will contain Key and Names, and in this table I will split Names into rows.
Thought about it, but real table contain almost 3 millions rows and not only 2 columns. If there is no other way I will create one more table which will contain Key and Names, and in this table I will split Names into rows.
amitchandak
Super User
Super UserAnonymous , if there are only two and as simple as as your data
CALCULATE( SUM(Value), filter(Table1, left(Table1[Names],1) IN VALUES(Table2[Name]) || filter(Table1, right(Table1[Names],1) IN VALUES(Table2[Name])) )