Forum Discussion
Solved
Calculate Sum Issue per row
I have multiple rows with the same order number but different products ship at different times. How do I get the total sale amount to be on the each row of the same order number? My goal is to have...
Try the following:
Total = CALCULATE(SUM([Amount]), ALLEXCEPT(Table, [Order]))
Try the following:
Total = CALCULATE(SUM([Amount]), ALLEXCEPT(Table, [Order]))
PERFECT!!!!! vicky_ Thank you! The ALLEXCEPT was what I was missing!