Forum Discussion
Sum computed incorrectly
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...
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.
Anonymous,
Can you provide you table structure ?
Also, are you creating a calculated column ? If yes, show us the code.
Ricardo
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.
Hi,
This has nothing to do with size. Just create a meaure as follows:
=SUM(Data[Cost])
Hope this helps.
