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...
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.