Forum Discussion
column subtotal not working
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.
2 Replies
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?
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
