title: MDX Combine two queries
body: <p>I need two join two queries, I tried with members but it didn't work. I am new to MDX, please let me know if there a way of doing this. Error is due to list in the calculated member.</p>
  
  <pre><code>SELECT NON EMPTY { [RR TYPE].[Item].[Item].ALLMEMBERS * [Measures].[Unit Value] } ON COLUMNS, 
          NON EMPTY { ([FFS].[FFSCD].[FFSCD].ALLMEMBERS) } ON ROWS 
  FROM  [GLCube] 
  WHERE ( [Location].[Site Name].&amp;[Sandbox]
          , [LT DT].[DATE HIERARCHY].[YEAR].&amp;[2010]
          ,-{ [Ledger].[ID].&amp;[A1],[Ledger].[ID].&amp;[A2] ,[Ledger].[ID].&amp;[A3]} ) 
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/D8t4I.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D8t4I.png" alt="enter image description here"></a></p>
  
  <pre><code>SELECT NON EMPTY {  [RT TYPE].[Item].[Item].ALLMEMBERS * [Measures].[Price Value] } ON COLUMNS, 
      NON EMPTY { ([FFS].[FFSCD].[FFSCD].ALLMEMBERS) } ON ROWS 
  FROM (SELECT [CCTYPE].[Desc].&amp;[FCD] ON COLUMNS 
          FROM [GLCube])
  WHERE ( [Location].[Site Name].&amp;[Sandbox]
          , [LT DT].[DATE HIERARCHY].[YEAR].&amp;[2010])
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/T8yMd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/T8yMd.png" alt="enter image description here"></a></p>
  
  <pre><code>Combined query
  
  WITH MEMBER [Measures].[Unit Value]] AS
      (-{[Ledger].[ID].&amp;[A1],[Ledger].[ID].&amp;[A2] ,[Ledger].[ID].&amp;[A3]},[Measures].[Unit Value])
  MEMBER [Measures].[Price Value] AS
      ( [CCTYPE].[Desc].&amp;[FCD],[Measures].[Price Value] )
  SELECT NON EMPTY {[Measures].[Unit Value],[Measures].[Price Value]} ON COLUMNS,
      NON EMPTY { ([FFS].[FFSCD].[FFSCD].ALLMEMBERS} ON ROWS 
  FROM  [GLCube] 
  WHERE ( [Location].[Site Name].&amp;[Sandbox]
          , [LT DT].[DATE HIERARCHY].[YEAR].&amp;[2010])
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/2CKQq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2CKQq.png" alt="enter image description here"></a></p>
  
  <pre><code>Expected Output
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/iYBde.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iYBde.png" alt="enter image description here"></a></p>