Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Here is a weird one. I am doing a basic Total Invoice Line Amount for example for that last two days.
If I do not SUM the amount I can see that all the values returned will add up to the correct amount but once I SUM it the amount is sometimes 1.5 times the amount or more.
Example when not sum:
Same data but now right clicked on Invoice Line Amount in the visualization and changed to SUM:
Any help with this is greatly appreciated.
Thank you.
Solved! Go to Solution.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |