my column total isn't working- as a measure, or as a total on the column either

[carmel_owen]

Hi, I want to sum a column. The column- 'Base Amount' when I summarize in a visual gives the incorrect total (column total should be -£2,823) and I have also created a measure to give me this total which is:

Base Amount Suppliers = CALCULATE(SUM('fact Accounting'[Base Amount]),'Supplier'[Account Code])

This is also giving the wrong total. I thought it would be a simple calculation, but have I oversimplified it, is there something I have missed here? Is it to do with the negative values? I have hunted through the forum and tried using some other calculated measures such as HASONEFILTER, but can't get any closer. Can anyone suggest a solution and help me understand where i've gone wrong?

[v-stephen-msft · Accepted solution]

Hi @carmel_owen ,

[Base Amout] from your screenshot is a column and the total sum of [Base Amout] is incorrect, right?

If the total of the column in your Power BI visual is wrong, there might be a few possible reasons:

You used a calculated measure instead of a calculated column. Measures apply the formula on the total instead of adding up the values of each row.
You did not consider the context and filters that affect the total. The total is calculated based on the visible rows and columns in the visual, not the underlying data.
Are the columns in your visual from different tables or the same table? It may be due to relationships that caused the wrong total.

Have you tried creating the simplest visual to see if total is correct? It's like below

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[miTutorials]

Is there a reason why you are passing a filter ? Just the below measure should help you get the total.

Base Amount Suppliers = CALCULATE(SUM('fact Accounting'[Base Amount]))