Forum Discussion
SUM Aggregation doubling the values
amansinghfirstb
I meant the #Item column, I can see them as duplicated .
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy Sorry but it didn't change this bug. Let me know if you need anymore information.
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.
