Forum Discussion
DAX Contains multiple values from list
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.
Super UserAnonymous , Try like
better to split Table 1[Name] into rows. if needed divide the value by count of elements
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
Anonymous , 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])) )