Forum Discussion
Total Display
This is not how it works. A total is not the addition of the rows in a visual. A total is the same formula applied with a different set of filters. I can't see what filters you have in your visual as you have cut them out. What you need to do is look at your formulas and evaluate them in your head given the filter context.
Read my article here to understand more http://exceleratorbi.com.au/sum-vs-sumx-in-dax/
also you would be well advised to read about best practice http://exceleratorbi.com.au/best-practices-power-pivot-power-query-power-bi/
As MattAllington said, the Total row doesn't add up all rows of values for this measure together. It uses the entire set in this table visual as filter context to slice this measure, and get the result as "grand total". So this result depends on filter context. For understanding filter context and row context, please refer to article below:
Row Context and Filter Context in DAX
Regards,