title: Calculated SSAS Member based on multiple dimension attributes
body: <p>I'm attempting to create a new Calculated Measure that is based on 2 different attributes.  I can query the data directly to see that the values are there, but when I create the Calculated Member, it always returns null.</p>
  
  <p>Here is what I have so far:</p>
  
  <pre><code>CREATE MEMBER CURRENTCUBE.[Measures].[Absorption]
   AS sum
  (
  
      Filter([Expense].MEMBERS, [Expense].[Amount Category] = "OS"
             AND ([Expense].[Account Number] &gt;= 51000 
             AND [Expense].[Account Number] &lt; 52000))
      ,
  
      [Measures].[Amount - Expense]
  ), 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Expense';     
  </code></pre>
  
  <p>Ultimately, I need to repeat this same pattern many times.  A particular accounting "type" (Absorption, Selling &amp; Marketing, Adminstrative, R&amp;D, etc.) is based on a combination of the Category and a range of Account Numbers.</p>
  
  <p>I've tried several combinations of Sum, Aggregate, Filter, IIF, etc. with no luck, the value is always null.</p>
  
  <p>However, if I don't use Filter and just create a Tuple with 2 values, it does give me the data I'd expect, like this:</p>
  
  <pre><code>CREATE MEMBER CURRENTCUBE.[Measures].[Absorption]
   AS sum
  (
  
      {( [Expense].[Amount Category].&amp;[OS], [Expense].[Account Number].&amp;[51400]  )}
      ,
  
      [Measures].[Amount - Expense]
  ), 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Expense';  
  </code></pre>
  
  <p>But, I need to specify multiple account numbers, not just one.</p>