Matrix - Subtract Row value from Total

Hi dtm644 

It seems the row the column totals subtract is the min value per column header.

So create a measure to get the min value per column header

Measure = MINX(ALLEXCEPT(Table1,Table1[column header]),[kpi])

Then create a new measure to replace the KPI measure

Measure 2 = IF(HASONEVALUE(Table1[state]),[kpi],[kpi]-[Measure])

If the column total on your side is correct as you expected, the formula above should get your expected result.

In my test, column total sums kpi values.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.