Data scientist here! What you have discovered is what’s known in data analytics as a semi-additive measure. Instead of summing the spend column, you would count it, and get a measure that showed how many transactions took place, but not a balance.