Creating the right measure for Totals between TWO Tables

[SteelChampzz]

I have a "SOLD" table and a "Orders" table.

I've already create a column that creates a total amount for each product type. I want to take the Total amount from each table and create a measure "SOLD[Total Amount] + ORDERS[Total Amount].

And use this measure to show the Total amount (of both tables together) for each product type. I've tried to use SUMX but the measure aren't showing the correct numbers I need it to.

Can someone show me where I maybe going wrong? Do I need to use a CALCULATE?

Thanks for the help

[amitchandak · Accepted solution]

@SteelChampzz , If they are columns, You need to have measures like

Sum(SOLD[Total Amount]) + Sum(ORDERS[Total Amount])

You need to have common product type table, please refer to how to create

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...