title: How to get sum value of unique ID's only ONCE in Tableau
body: <p>I'm using Tableau Desktop 10.2</p>
  
  <p>I have multiple data sources that are joined together through left joins:
  <a href="https://i.stack.imgur.com/kx0ov.png" rel="nofollow noreferrer">Data Setup</a></p>
  
  <p>This causes an issue for me as I'd like to get the total of my pipeline (yellow box). Right now, because of the way I've joined everything, my pipeline is huge since all the ID's are being added:</p>
  
  <p>ID - Value ($M)</p>
  
  <p>1234 - $100M</p>
  
  <p>5678 - $50M</p>
  
  <p>5678 - $50M</p>
  
  <p>1234 - $100M</p>
  
  <p>1234 - $100M</p>
  
  <p>9101 - $20M</p>
  
  <p>Right now, my total value is $420M, when it should be $170M.</p>
  
  <p>I'd like to keep the joins because my dashboards contain filters I'd like to affect worksheets.</p>
  
  <p>Any idea on what I can do?</p>