I'm currently trying to calculate in a measure the last amount chosen in a checkout process. This needs to be identified by customer ID. The last chosen amount can be identified by using the Action ID (indexes order of events, but does not reset by customer).
Three columns are Action ID, Amount Chosen, and Customer ID (see image URL below).
EDIT 1/29/19: The output should also exclude $0's as an output option unless the Customer ID lacks a "Confirmed". The final purpose would be to have a sum of the "Desired Output".
Example data
Action ID Amount Chosen Customer ID Desired Output
1 $10 1
2 $15 1 $0
3 $20 2
4 $25 2 $25
5 $0 2
6 Confirmed 2