Yes, that was the answer I was looking for. I ended up being able to tweak my formulas to come up with the calculated columns I needed:

TotalPayments:=CALCULATE(SUM(Payment[PaymentAmount]),FILTER(Payment,Payment[CustomerID] = Sales[CustomerID])))

BalanceDue:=Sales[SaleAmount] - Sales[TotalPayments]

Thanks for the help!