Incorrect summary of column (not a measure)

[e_vera]

Hi,

Could someone please help me understand why the amountpaid total is not computing the sum of the column amount? This amountpaid is a column in the database (summation icon is indicated instead of a calculator), it's not a measure so no formula has been applied. With or without filter under transactiontype column, this amountpaid column does not obtain the total sum at all (number column does not have this issue though), help please? Thank you in advance!

 

[v-lionel-msft · Accepted solution]

Hi @e_vera ,

The incorrect data you said is this , right?

The data should be ($434,398,755.05 + $318.85), right?

“This amountpaid is a column in the database…”

If the [amountpaid] column is not from a DAX formula, the error may come from your table model.

Do the three columns you used come from the same original table?

If they come from multiple original tables, please check the relationship between tables.

As tested, if the original tables have wrong relationship, the error will occur.

Best regards,
Lionel Chen

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

[e_vera]

Hi Lionel,

Thank you for your feedback. Yes, it's coming from multiple original tables. Will check their relationship as suggested, hopefully that will fix the issue. Thanks again!