column subtotal not working

[Nash2Bos]

Hello all, 

i have an excel data sheet that i moved into powerBI in a matrix table. 

The table looks like this

City	Plans	Week 1	Week 2	Week 3	Week 4	Week 5
Boston	Plan	5	10	5	12	10
	Actual	5	11	0	2	10
	+/-	0	1	-5	-10	0

When i do the column subtotal it comes up with -5 instead of -14. 

Thank you all. 

[Anonymous]

Hi @Nash2Bos 

In Matrix visual, the subtotal and grand total values are calculated based on the underlying data instead of the visible data displayed in the visual. I guess in the underlying table, the data is not displayed as you show, and you probably use some measures to calculate the result. This would lead to the unexpected subtotals. Please share some sample data (dummy data) of the underlying table and share the measure DAX you used. We may need to modify the measure or create a new one. 

Best Regards,
Jing

[HankScorpio2]

Are you referring to the row total for +/-? 

City	Plans	Week 1	Week 2	Week 3	Week 4	Week 5
Boston	Plan	5	10	5	12	10	42
	Actual	5	11	0	2	10	28
	+/-	0	1	-5	-10	0	-14

What is the measure you are using?