title: Can't get filter to work with multiple conditions
body: <p>I'm trying to make a MDX query for use with SSRS later on. To start with the basic query that works:</p>
  
  <pre><code>Select NON EMPTY {
  [Measures].[Score %]
  ,[Measures].[Month Key]
  } on Columns,
  NON EMPTY {
  ([Date].[YMD].[Month Name].&amp;[201301])
  * FILTER([Customer].[Customer Full Name].[Customer Full Name].members,
          ([Measures].[Score %], [Date].[YMD].&amp;[201301]) &lt;&gt; null
      AND ([Measures].[Score %], [Date].[YMD].&amp;[201301]) &lt;&gt; 0 ) 
  } on Rows
  
  from [Cube]
  </code></pre>
  
  <p>But this is only for one month. in SSRS i want to be able to select multiple months, so i altered my query to this:</p>
  
  <pre><code>Select NON EMPTY {
   [Measures].[Score %]
  ,[Measures].[Month Key]
  } on Columns,
  NON EMPTY {
  ([Date].[YMD].[Month Name].&amp;[201301] : [Date].[YMD].[Month Name].&amp;[201307])
  * FILTER([Customer].[Customer Full Name].[Customer Full Name].members,
          ([Measures].[Score %], ([Date].[YMD].&amp;[201301] : [Date].[YMD].&amp;[201307]))&lt;&gt; null
      AND ([Measures].[Score %], ([Date].[YMD].&amp;[201301] : [Date].[YMD].&amp;[201307])) &lt;&gt; 0 )
  } on Rows
  
  from [Cube]
  </code></pre>
  
  <p>But here i get an error: The &lt;> function expects a string or numeric expression for the 1 argument. A tuple set expression was used.</p>
  
  <p>As far as i understand it is because i'm returning multiple months in my set where it expects one month. So i write the next query:</p>
  
  <pre><code>With
  Set [QC relation]
  as FILTER([Customer].[Customer Full Name].[Customer Full Name].members,
            ([Measures].[Score %], [Date].[YMD].currentmember) &lt;&gt; null
      AND   ([Measures].[Score %], [Date].[YMD].currentmember) &lt;&gt; 0 ) 
  
  Select NON EMPTY {
   [Measures].[Score %]
  ,[Measures].[Month Key]
  } on Columns,
  NON EMPTY {
  ([Date].[YMD].[Month Name].&amp;[201301] : [Date].[YMD].[Month Name].&amp;[201307]) 
  * [QC relation]
  } on Rows
  
  from [Cube]
  </code></pre>
  
  <p>But here it seems my filter doesn't work properly. It is returning all the rows with a score in the data for each month so i have a lot of null values.</p>
  
  <p>How do i get the proper results for each month without the null values? 
  I'm working with SSMS/SSAS on SQLServer2008</p>
  
  <p>Thanks</p>