Forum Discussion
k3rz0rg
Advocate III
Advocate IIITable Visual Total is not showing correct value!
Hi everyone,
I've been working on a table visual and noticed the Total is not showing me the correct value for the column 1 and 3 which are whole numbers type. The other 2 which are currency type are showing good! Can somebody help?
Thanks!
1 Reply
vicky_Super User
If Columns 1 and 3 are measures, then there is a chance that you will need to modify the calculation for the total row to display the value you want. Check out Greg Deckler's post here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Otherwise, there's a chance that the totals is not double-counting because you've selected some aggregation like Count Distinct (and there's an overlap in the data).