title: MDX filter member in where clause vs filter member in From clause
body: <p>IN ADVENTURE WORKS what is difefrence between this two situations:</p>
  
  <p>1) filter member in From Clause:</p>
  
  <pre><code>with
  member [existing_categries_Member_Count]as
      count(existing[Product].[Category].[Category].members)
  member [existing_subcategries_Member_Count]as
      count(existing[Product].[subCategory].[subCategory].members)
  select 
  {
      [existing_subcategries_Member_Count],
      [existing_categries_Member_Count]
  } on 0
  FROM (
      SELECT [Product].[Subcategory].&amp;[31] ON 0
      FROM [Adventure Works])
  </code></pre>
  
  <hr>
  
  <p>Results:</p>
  
  <pre><code>existing_subcategries_Member_Count  existing_categries_Member_Count
                      37                            4
  </code></pre>
  
  <p>AND 
  2) Filter Member In WHERE Clause:</p>
  
  <pre><code>with
  member [existing_categries_Member_Count]as
      count(existing[Product].[Category].[Category].members)
  member [existing_subcategries_Member_Count]as
      count(existing[Product].[subCategory].[subCategory].members)
  select 
  {
      [existing_subcategries_Member_Count],
      [existing_categries_Member_Count]
  } on 0
  FROM [Adventure Works]
  WHERE [Product].[Subcategory].&amp;[31]
  </code></pre>
  
  <hr>
  
  <p>Results :</p>
  
  <pre><code>existing_subcategries_Member_Count  existing_categries_Member_Count
                     1                              1
  </code></pre>
  
  <p>I expect the same results for the two queries but I see diffrent results.
  Please tell me the difference between WHERE AND SUbcube
  thanks</p>