title: How to filter Power BI table using list of keywords (in a column in other table)
body: <p>I have a big data table with a column called Account Name. In another table (<em>Accounts</em>) I have a column of Account Keywords that contains parts of full account names. I want to filter the big data by column 'Account Name' using the list of keywords in the 'Acount Keywords' list.</p>
  
  <p>I've created a new measure in the big data table called 'Filter Accounts' with the following DAX:</p>
  
  <pre><code>FILTER ACCOUNTS = contains(Accounts,Accounts[Account Keyword],Big_Data[Account Name])
  </code></pre>
  
  <p>But the "contains" function works on exact matches. I want it to return true if the 'Account Keyword' is found within any part of the 'Account Name' field. I also want it to ignore case.</p>
  
  <p>The DAX statement results in TRUE only for exact matches. How do I modify my DAX to achieve the desired non-exact matches?</p>