Calculate Sum Issue per row

[jboschee34]

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 the $16 show on each row.

Order   Date   Amount     Total
1           1/1         $5          $16

1           1/3         $7          $16

1           1/5         $4          $16

[vicky_ · Accepted solution]

Try the following:
Total = CALCULATE(SUM([Amount]), ALLEXCEPT(Table, [Order]))

[jboschee34]

PERFECT!!!!! @vicky_   Thank you!  The ALLEXCEPT was what I was missing!