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!