Adding custom column with sum of sales from another table

[Reetz]

Hello.  I am VERY new to PowerBI.  I am trying to add a calculated column to Table 1.  See below.  I want to total the Sales for each Acc# in table 2 and add that total to Table 1 for each matching acct#.  How do I do that?

[v-chuncz-msft · Accepted solution]

@Reetz,

You may use DAX below.

Column =
SUMX ( FILTER ( Table2, Table2[Acct#] = Table1[Acct#] ), Table2[Sales] )