Joining a 1:N table before an aggregate multiplies the measure once per child row. A deal with five history rows counts its amount five times. Aggregate the N side first, in a CTE, then join. This is the most common way a total gets silently inflated.