Lookup or Related - sum the column based on matched row.

[mattrixdesign2]

I have a table containing rows:

Account #

Part #

Account #/Part # (Combines from the above)

I have another table containing rows:

Account #

Part #

Account #/Part # (Combines from the above)

Extended Price 

The relationship is ONE to MANY. I would like to add a column to the initial table that is a sum if Extended Price at account #/part # level.

Not sure where to begin with this.

[gmsamborn]

Hi @mattrixdesign2 

If I understand correctly, you calculated column should look something like this.

Column = CALCULATE( SUM( 'Table2'[Ext Price] ) )

LOOKUP or RELATED.pbix

I hope I understood correctly.