Correct Row Totals but Incorrect Row Totals on Table Matrix

@VincentJT,

Welcome to the forum! – great to have you here.

I actually just worked through a nearly identical situation with a member last week. In a matrix, you have four separate evaluation contexts you have to deal with individually. I find that rather than using the SUMMARIZE/SUMX construct that works so well for correcting totals in a table with only two different evaluation contexts, the SWITCH(TRUE)/HASONEVALUE construct in the solution below works better to control for the four separate contexts.

The solution above also contains a PBIX file that will allow you to deconstruct the details of the solution. If you still have questions or problems after going through that, just give a shout and I’ll be happy to work through the issues with you.

I hope this is helpful.

  • Brian