I have a task where two tables.
The first table without date field, second with. They are joined by the field "Group", it is the first field from my screenshot.
I need to calculate the sum of the difference between the two measures.
Measure from the first table i calculate as Measure1 = SUM('Table1'.[Field1])
The second measure from table 2 i calculate as Measure2 = AVERAGE('Table2'.[Filed2])
The problem is I can't get the correct total of difference between fields, but in rows all is correct.
I already tried SUMX, AVERAGEX. Tried to store the result of values on VAR, but it doesn't help