title: DAX sub-total wrong when filtered by other filter
body: <p>I have a power pivot summarising sales data on various levels of hierarchy. </p>
  
  <p>I have added a picture showing data structure and expanded examples to be more illustrative.</p>
  
  <p>The data has products and countries. </p>
  
  <p><img src="https://i.stack.imgur.com/MUUlA.jpg" alt="PICTURE WITH SAMPLE OF DATA"></p>
  
  <p>My task is to return a "category total" of sales, which should respect all geographical filters, but ignore product filters. </p>
  
  <p>This is the DAX I am using </p>
  
  <pre><code>Sales Total:=SUM([Volume])    
  </code></pre>
  
  <p>(this measure is an explicit sum of original volume data field)</p>
  
  <pre><code>Category Totals:=
         CALCULATE( [Sales Total], 
                    ALL(TBL[brand], 
                        TBL[Sub-brand], 
                        TBL[SKU]
                       )
                    )
  </code></pre>
  
  <p>this is the measure where I'm trying to capture totals above product level - called "Category" because it sums up all products in a geographical set, be it a market, region, sub-region. </p>
  
  <p><a href="https://i.stack.imgur.com/3AV7n.jpg" rel="nofollow noreferrer">PICTURE WITH MY RESULTS:</a></p>
  
  <p>Problem 1: when geographical field is filtered indirectly, sub-totals do not reflect that (i.e. market doesn't have for Brand 2).</p>
  
  <p>Problem 2: if a product attribute (i.e. Brand) is higher in hierarchy of row fields than geographical (i.e. market etc), sub-totals on that level show a global total at all times instead of sub-totalling regions/markets that they belong to. </p>