Wrong Aggregated values in Clustered Column Chart

[Anonymous]

I have created a simple column chart showing the week on week sales but the aggregation is wrong using Sum and chart shows wrong values. I have a following data (sample):

Employee	Week	Sales
1	1	100
1	2	200

I am getting the total wrong value in the chart for the same. Can some one help here?

[Bibbert]

I am having this same problem.  I have two columns of data, both of which are formatted as whole numbers and contain either the value 1 or null.  One column it sums correctly (a total of 29), the other column it does not (returns the same, lesser value of 29 instead of the 40 that you can visually see in the table).  Any thoughts?

[v-yingjl]

Hi @Anonymous ,

How did you create this column chart? Basically it works fine in my side as far as my test.

Perhaps you can check the data type or sharing more details about it.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous what is your DAX measure expression look like? You have provided very little information and it is not very helpful.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

This is a column directly from the data. I have not created any measure. Still the aggregation is not correct.