My DAX in the screenshots isn’t working.
In Screenshot 1, the Row calculations seem correct, but the Total of the Column isn’t the Sum of the Rows (it’s a lot lower: See Screenshot).
In Screenshot 2, I’m returning 2 slightly different Multiplication formula. On the right, the Column Total = the sum of the Rows, but Each Row doesn’t seem to be the Multiplication of the Columns to the left (i.e. 22389 * 6 * 0.941 = 126408 and not 134294). On the left, the Column Total (462621) does not = Sum of the Rows (509542).
Any chance of an explanation and advice on what to use for a correct result?