Forum Discussion
Invoice Line Amount incorrect when using SUM
MP-iCONN I guess in the first image you don't have any aggregation, it is possible that there are rows with the same value on the same date, and in that case, it will only show one row and when you use aggregation (SUM in 2nd image), it sums all the rows and it looks like the wrong sum.
If you add another column (say same invoice date column) in the 1st image and change its aggregation to count, you will find out what rows has more than one row and you will get your answer.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
MP-iCONN I guess in the first image you don't have any aggregation, it is possible that there are rows with the same value on the same date, and in that case, it will only show one row and when you use aggregation (SUM in 2nd image), it sums all the rows and it looks like the wrong sum.
If you add another column (say same invoice date column) in the 1st image and change its aggregation to count, you will find out what rows has more than one row and you will get your answer.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡