Regular sum in the table mismatched from excel sum

[takui12]

Hi guys, this fact is making me going crazy...I've a simple table, that shows my data, and it's sum is a number, for example, 10. Exporting those data in Excel, I've noticed the sum isn't the same, but 9, always less than power bi. I've tried to extract less than 1000 rows, I've still a different total. In powerbi, trying to count the rows (for example, making the value column doing a count instead of sum), seems the records differs in number from those it extract me, what's happening?

just to give you some context:

from power bi:

from power bi counting:

from excel

[_AAndrade · Accepted solution]

Hi @takui12,

Try to see how many rows do you have in your power bi table on the table view.
This information appears in the bottom left-hand corner, something like this:

Make sure that you don't have any filter applied on that table and compare to the number of rows hou have on the excel file.

[_AAndrade · Accepted solution]

Hi @takui12,

Try to see how many rows do you have in your power bi table on the table view.
This information appears in the bottom left-hand corner, something like this:

Make sure that you don't have any filter applied on that table and compare to the number of rows hou have on the excel file.

[takui12 · Accepted solution]

Hi there, thank you for the answer. I've got it, to me it's weird to understand because I thought it would gave e a blank line but, just to explain:

I had a connected table with a list of code, that I've matched with my data table, to give it a description (for example, in the data table I had 200 as number, in the matching table I've made, I've a column with 200 and on the side, the description). In this table I've made, I've missed 1 code. This hole, worked as a filter...instead of showing me a blank line with all those withouth a description, It filtered out the lines, even if the total was still summing their value...quite crazy

thanks again

[dk_dk]

In addition to what @_AAndrade says, you could try to re-import the excel file you have exported into power bi, connect it to the existing data you already have (assuming you have some unique ID) and find out that way which rows are missing from the excel export. Maybe it will help figure out the reason.