Forum Discussion
Solved
Sum Unique Quantity for Total Correct
I have worked with this for a couple of days and I really can't find the solution. I appreciate the support you can give me. In a data that has the color, id number and quantity I am trying to unify...
lc_finance
Solution Sage
Solution SageHi GKs
Based on the Power BI I sent yesterday, Third is no longer equal to Second even if Id is taken away from the table.
In the example, the total for Third is 84 and the total for Second is 241.
84 is the sum of 68 for transaction 8326 and 16 for 8468.
A paste a screenshot below.
Is this what you are looking for?
LC
Yes, you did it.
But you won't believe me for some reason, my Power BI doesn't SUM well, download the file I did't make any modification just remove the id from the table. I don't know why this happens, If it's an update that I don't have or maybe I did.
- lc_finance