title: MDX Filter Unknown from list of states / provinces also removes provinces
body: <p>I am trying to exclude Unknown from a dimension [Ship To State] that contains Provinces and States.</p>
  
  <p>The first expression throws out Provinces as well as States, and I don't know why -</p>
  
  <p>this mdx lists only states (excludes Unknown, and for some reason, Provinces):</p>
  
  <pre><code>WITH 
  MEMBER measures.ParameterCaption as [Ship To].[Ship To State].currentmember.member_caption
  
  MEMBER measures.ParameterValue as [Ship To].[Ship To State].currentmember.uniquename
  SELECT {measures.ParameterCaption, measures.ParameterValue}  ON COLUMNS,
  FILTER([Ship To].[Ship To State].children,
  
  [Ship To].[Ship To State].currentmember&lt;&gt;[Ship To].[Ship To State].&amp;[Unknown]
  
  ) ON ROWS
  FROM [Invoiced Orders]
  </code></pre>
  
  <p>this mdx lists states and provinces correctly, and excludes Unknown:</p>
  
  <pre><code>WITH 
  MEMBER measures.ParameterCaption as [Ship To].[Ship To State].currentmember.member_caption
  MEMBER measures.ParameterValue as [Ship To].[Ship To State].currentmember.uniquename
  SELECT {measures.ParameterCaption, measures.ParameterValue}  ON COLUMNS,
  FILTER([Ship To].[Ship To State].children,
  
  measures.ParameterCaption &lt;&gt; "Unknown"
  
  ) ON ROWS
  FROM [Invoiced Orders]
  </code></pre>