Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
CONTAINS
DAX
Measures
values
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try like

 

better to split Table 1[Name] into rows. if needed divide the value by count of elements

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

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