Sum computed incorrectly

Anonymous · ‎03-06-2018

Hi PBI users,

I am adding a column name and cost to a table. As usual, cost is aggregated to sum which is displayed as 6000. But the actual sum is 1000. The table is not joined to any other table. I tried this again in a new report, same issue exists.

Could anybody please help?

ricardocamargos · ‎03-06-2018

Hi @Anonymous,

Can you provide some data as sample, also show us your table structure ?

Ricardo

Anonymous · ‎03-06-2018

Hi @Anonymous, @ricardocamargos,

Thank you for your responses.

I am simply adding a column to the table, no measures involved.

Please refer to the attachment. Observe that when I click on "SUM" instead of "Don't Summarize", the values change too.

ricardocamargos · ‎03-06-2018

@Anonymous,

Can you provide you table structure ?

Also, are you creating a calculated column ? If yes, show us the code.

Ricardo

Anonymous · ‎03-06-2018

@ricardocamargos,

This is not a calculated column.

Could this be due to the size of the table? When I reduced the size of the table to a couple of rows, instead of 1M rows, it calculates the Sum correctly.

Ashish_Mathur · ‎03-06-2018

Hi,

This has nothing to do with size. Just create a meaure as follows:

=SUM(Data[Cost])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎03-06-2018

Hi @Ashish_Mathur,

I tried that as well, doesn't work.

Ashish_Mathur · ‎03-06-2018

Hi,

Share the link from where i can download your file (please ensure that the file siz is only a few KB's) and show the expected result there.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎03-06-2018

@Ashish_Mathur

As soon as I reduce the size of the file and recreate the table, it works fine.

But that is not a solution to the problem. I need to have those 1M rows in my table.

Ashish_Mathur · ‎03-07-2018

Hi,

I cannot help unless i have that file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎03-06-2018

When you say you have added "Cost to the table". Do you mean you created a calculated column to store the cost inside the table?

A cost measure should be able to achieve the values you need and not have the aggregation issue. Can you post some data examples and what you are trying to achieve? Its really hard to guess what you are stuck with.