Subtraction Problem between two tables

[jkesavan]

Hi all, i am currently trying to do a simple subtraction between two columns from 1 table and then followed by another subtraction from another table. They are all $ values but i keep getting this error.

[amitchandak · Accepted solution]

@jkesavan , In case you are

creating a measure

Sum(Table1[Col1]) + Sum(Table1[Col2]) -Sum(Table2[Col1])

if you create creating a column in table 1

Table1[Col1] + Table1[Col2] - sumx(Filter(Table2, table2[Id] = Table1[Id]),Table2[Col1])