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/
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/