Sum computed incorrectly

[Anonymous]

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]

Hi @Anonymous,

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

Ricardo

[Anonymous]

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]

@Anonymous,

Can you provide you table structure ?

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

Ricardo

[Anonymous]

@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]

Hi,

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

=SUM(Data[Cost])

Hope this helps.

[Anonymous]

Hi @Ashish_Mathur,

I tried that as well, doesn't work.

[Ashish_Mathur]

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.

[Anonymous]

@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]

Hi,

I cannot help unless i have that file.

[Anonymous]

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.