It shows incorrect total number from data column

[g10043014]

This table comes from the data not the report. When I create a report to sum this column, and it shows incorrect number for each cusomter. For instance, sum up the total number should be 3 (0.33+0.33+0.33+0.5+0.5+1) in customer A but I pull data into report table and it shows 1 which is incorrect total number for customer A from raw data.

The measure is sum(‘customer table’[Total Number])

[v-yingjl]

Hi @g10043014 ,

If only calculate the sum value, the formula should work basically. What's the table strcture look like and the column data type? Perhaps you can consider sharing the sample tabla about this thread.

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

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.

[lbendlin]

Familiarize yourself with CALCULATE and the filter functions like ALL or ALLSELECTED, and the concept of filter context.