Forum Discussion
Sum values in column on Unique value
OrderID OrderTotal Item 000123 100 0078 000123 100 0081 000123 100 0096 000789 59 0078 The Total returned for order 000123 was 300 when it really should be 100. So the...
Hi Anonymous
I restore your data and create a sample , the sum of [OrderID] is 159 . I have attached my pbix file , you can refer to it and check the original data in your sample .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
I restore your data and create a sample , the sum of [OrderID] is 159 . I have attached my pbix file , you can refer to it and check the original data in your sample .
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.