Table not Totaling Sum, a specific row is left out of total sum

[gonzna3]

I have a Table like the below example, where the 2 columns with amount are not totaling the sum correctly.

Name  Amount1  Amount2  Variance

Ben      1               2                1

Kate     2               2                0

Sam     1               1                0

Total     3              3                1

Is anyone encountering this issue? Is there a fix?

[v-sihou-msft · Accepted solution]

@gonzna3

Are both Amount1 and Amount2 columns or measures?

If they are measures, please verify the DAX. 

If they are columns, please check the aggregation of these two columns. Make sure it's "Sum".

Regards,