title: Dynamic sum in dax picking distinct values
body: <p>Below is sample data</p>
  
  <pre><code>Week Practice  Type capacity   Gen
  1       BI      c       80      0
  1       BI      c       80      1
  1       BI      sc      160     1
  1       BI      pc      240     0
  1       BI      pc      240     3
  1       BI      mc      1160    1
  1       BI      mc      1160    4
  1       BI      mc      1160    2
  1       BI      ac      440     1
  1       BI      d       40      0
  1       BI      d       40      3
  </code></pre>
  
  <p>I have a pivot chart, that has 3 slicers namely PRactice, Type, and gen.</p>
  
  <p>when I don't select any slicer, it should be a distinct sum(capacity) ie.,2120. Then when I click on type slicer say mc Sum(capacity) should be 1160 and click on only gen say 3 and clear other filters then <code>sum(capacity) = 280</code>.</p>
  
  <p>There can be many practices and many weeks.</p>
  
  <p>Need dax query to meet this requirement.</p>