Forum Discussion
SUM Aggregation doubling the values
amansinghfirstb
Not clear ,
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
So, the column Miss = Order_Qty - Qty_Shipped
The problem is that I can't share the pbix file as it's confidential and cleaning the requisite keys would just kill the whole thing.
did you find a solution? i am having same problem. where new column Total = 1+1 return turns out to be 4 instead of 2. I am not sure why is that happening.
