DAX calc. column that displays the value from one column based on the max value in another column

[egarstad]

Hi All,

I am new to DAX and have been trying to solve this problem for a few days now with no luck. I have found multiple forum posts with similar requests but none that solve my exact situation.

Any help would be much appreciated and thank you in advance!

I have the following table containing manufacturing information. An Order #, an Operation # within that Order #, and the Output Qty of that operation:

I would like to add a DAX calculated column that, for every row, displays the Output Qty of the final operation in the order:

I hope that makes sense. It seems like fairly straight forward logic to me but I just cannot come up with a DAX formula that works.

[fhill · Accepted solution]

See if this works, I'm worried if you have other filters, they may impact the results...

Forrest

Qty - Max Op by Order = CALCULATE(

                   SUM(Table1[Qty]),

                            FILTER(Table1, Table1[Op #] = CALCULATE(

                                            MAX(Table1[Op #]),

                                           ALLEXCEPT( Table1, Table1[Order #]))),

                                           Table1[Order #] = EARLIER(Table1[Order #]))

[lopa123]

Hi, how would be the same formula but filling only the rows with the result in the corresponding rows? like this image

[egarstad]

Works like a charm. Thank you for the quick response!