cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gonzna3 Frequent Visitor
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

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

@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".

 

2.PNG

 

Regards,

 

 

1 REPLY 1
Moderator v-sihou-msft
Moderator

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

@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".

 

2.PNG

 

Regards,