title: PowerBI Desktop - SUM Ignoring Filters
body: <p>My visual has a simple data table which has a number of rows, each representing an invoice. Each invoice has a number of items, including the sales rep, creation date, and the amount.</p>
  
  <p>I have a number of slicers including sales rep, date of creation, etc.</p>
  
  <p>I'm trying to add a column which, for each row, shows the percentage that that particular invoice is of the shown invoices. So, for example, when I use a filter to only show a subset of all rows, I want each row to show a percentage of the total of that subset, not the percentage of all rows.</p>
  
  <p>Imagine this table:</p>
  
  <pre><code>|ID|Rep |Value|Percentage|
  | 1|Dave|   10|        50|
  | 2|Sue |    3|        15|
  | 3|Dave|    5|        25|
  | 4|Sue |    2|        10|
  </code></pre>
  
  <p>The Percentage column is created by Value/SUM(Value) and is showing correctly above. The SUM(Value) is 20; Dave's 10 is 50% of that, Sue's 3 is 15% of it, and so forth.</p>
  
  <p>I have a slicer for Rep. So if I choose 'Dave' in that slicer, the table looks like this:</p>
  
  <pre><code>|ID|Rep |Value|Percentage|
  | 1|Dave|   10|        50|
  | 3|Dave|    5|        25|
  </code></pre>
  
  <p>The Percentage column is being created based on the SUM(Value) of ALL rows (i.e. 20) not just the ones that are showing because of my slicer (i.e. 15). I would have expected the percentages to be 66.67% and 33.33%, being the percentages of the total of what's showing. Why isn't it? And how do I get it to be?</p>