Forum Discussion
Solved
Sumx calculation per row between 2 tables
Hi all, I want to calculate a difference per ROW rather than the TOTAL by subtracting values from 2 seperate tables. I thought using SUMX would help me rather than SUM. Absolute Error = ABS...
I found the solution.. the formula works as the relationship is established. However I had to create a new column for the calculation, not a new measure! Thanks for your advice :)
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi Reits,
Do you mean the 2 seperate tables are not related with each other? If so, with above formula, you will get the total values across entire table with SUMX rather than per row. That is why the number you get is very high.
As Floriankx suggested, please generate relationship between two tables.
Regards,
Yuliana Gu
I found the solution.. the formula works as the relationship is established. However I had to create a new column for the calculation, not a new measure! Thanks for your advice :)