Sum of measure not correct

[Anonymous]

Hello,

I have the following results from measures, see picture.

If I sum all values it supossed to be 214,923.79 and 170,897.42.

Any idea why the measure doesn´t properly?

cheers

[v-frfei-msft]

Hi @Anonymous ,

I’ve checked it and it works well on my side.  Please find the details below:

Assuming that we have original column A and B, we’d like to sum the measure of [B] – [A], formula could be like this 

Measure = SUMX(Table2,CALCULATE(SUM(Table2[B])-SUM(Table2[A])))

[Anonymous]

Hello,

Thank you for your answers. Unfortunately, it does not work, but I may have found a clue why.
My measure takes the maximum of each row from two columns. But it takes for the sums also the maxima of the two column sums. Actually it should use the sum of the individual values.

PrognEndw VAR = MAX(<Table>[Bud+Prog. VAR];[MAX-IstSoll VAR])

[v-frfei-msft]

Hi @Anonymous,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous]

Grand totals are just the figures after one or more filters is removed. The fact that they sum out is basically a coincidence. You need to force the totals to be correct. You can follow this template:

Force Sum =
sumx( values( <whatever is on rows in your table>), [measure] )