Group by with Related Tables

[Maureen]

I have the two tables below and want to sum by product.  I have linked to the two tables by product id but the sum for product ID gives me the results in the third pictures.  I thought this will work seamlessly.  Do I actually have to create a new table just to aggregate by product when I have linked to another table showing product cost?  

[v-cherch-msft · Accepted solution]

Hi @Maureen 

I would suggest you add a cost column with RELATED function as below.Then drag the cost column to table visual.

Cost = RELATED(A[Cost])

Regards,

Cherie