title: Sum distinct values for first occurance in Power BI
body: <p>In Power BI I have some duplicate entries in my data that only have 1 column that is different, this is a "details" column.</p>
  
  <pre><code>Name   | Value | Details
  Item 1 | 10    | Feature 1
  Item 1 | 10    | Feature 2
  Item 2 | 15    | Feature 1
  Item 3 | 7     | Feature 1
  Item 3 | 7     | Feature 2
  Item 3 | 7     | Feature 3
  </code></pre>
  
  <p>I realize this is an issue with the data structure, but it cannot be changed.</p>
  
  <p>Basically, when I sum up my Value column on a Power BI card, I only want it to sum for each unique name, so in this case:</p>
  
  <pre><code>Total = 10 + 15 + 7 
  </code></pre>
  
  <p>I will be using the details in a matrix, so I cannot simply remove the duplicates from within the Query Editor.</p>
  
  <p>Is there any way I can filter this with a DAX formula? Just summing the first occurrence of an item?</p>