title: MDX: Filtering and slicing on different members of the same dimension
body: <p>I am using icCube's Sales cube to learn MDX. I would like to write an MDX query to show the revenue from sales in 2009 for those countries where the revenue from sales in 2010 was over $80,000. I tried the following, but it returned an empty table with only one column ([Amount]):</p>
  
  <pre><code>WITH
   SET [myset] AS Filter([Country].members, ([Measures].[Amount], [2010])&gt;80000)
  select [Country].members on 0, [Amount] on 1
  from (select [myset] on 0, [Amount] on 1 from [sales])
  where [2009]
  </code></pre>