title: How To Filter a list in String with MDX
body: <p>Goal:<br>
  Filter the value in the table column based on string "Canada" as a criteria.</p>
  
  <p>Problem:<br>
  I cannot get the MDX syntax code in where state to be correct in order to filter the data based on <code>Canada</code>.</p>
  
  <p>Information:  </p>
  
  <ul>
  <li>This situation is a simplified sample and my request is to add filter criteria in the where state.    </li>
  <li>Data source is SSAS:s AdventureWorksDW2012 </li>
  </ul>
  
  <p>Code:</p>
  
  <pre><code>SELECT
  { 
      [Measures].[Reseller Order Count], 
      [Measures].[Discount Amount] 
  
  } ON COLUMNS, 
  { 
      ([Reseller].[Reseller Type].[Business Type].ALLMEMBERS ) 
  } ON ROWS 
  FROM  [Adventure Works]
  WHERE
  (
      FILTER
      (
                  [Geography].[Country].ALLMEMBERS, [Geography].[Country].NAME ='Canada'
      )
  )
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/L8Xwk.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/RQaAd.png" alt="enter image description here"></p>