Forum Discussion
Incorrect total in Power Bi
Hi,
I have a decimal column in Power Bi with positive and negative values, when I put that column (by itself) to a graph or a table I get a total of -2 billion, but when I copy it to excel and get the total it gives me a different number (like 194 million) which is the correct answer I am looking for. I have no idea why power Bi sum incorrectly and I need to show totals in my report.
Please help,
Thank you!
Use tables to check your values.
Ensure the you have the correct default aggregation. Select the column and look under Modelling. Maybe it's a count not a sum.
Is this just a value or a DAX Measure?
Add some slicers to check the value with smaller data sets.
Also try duplicating the Query Editor Query and grouping with a SUM does this give the same value?
1 Reply
Use tables to check your values.
Ensure the you have the correct default aggregation. Select the column and look under Modelling. Maybe it's a count not a sum.
Is this just a value or a DAX Measure?
Add some slicers to check the value with smaller data sets.
Also try duplicating the Query Editor Query and grouping with a SUM does this give the same value?