title: DAX Summing Values in Another Table
body: <p>I am new to DAX.</p>
  <p>I have 2 tables. Let's call them <code>Table_1</code> and <code>Table_2</code>.</p>
  <p>Let's say they look like this:</p>
  <pre><code>Table_1
  
  ID     Table_2_ID     Person
  1      1              Steve
  2      1              Steve 
  3      1              Steve
  4      2              John
  5      2              John
  6      3              Sally
  
  
  Table_2     Sales
  1           100
  2           50
  3           5
  </code></pre>
  <p>I want to return results that look something like this:</p>
  <pre><code>ID     Table_2_ID     Person     Sales
  1      1              Steve      100
  2      1              Steve      100
  3      1              Steve      100
  4      2              John       50
  5      2              John       50
  6      3              Sally      5
  </code></pre>
  <p>How can I return this with a Dax function?</p>
  <p>I know I need to use LOOKUPVALUE and/or the RELATED function, in combination with SUM, but I'm not sure how.</p>
  <p>I'm not looking to produce a table, but a measure that when I use it in combination with other columns in Power BI, it applies the appropriate amount to each person in <code>Table_1</code>.</p>