Hi Power BI experts, I was hoping you could help me out with an issue that I’ve been having with incorrect row totals on the table matrix. Background I am trying to calculate the month on month FX impact on profit margins by different currency pairs Total FX Impact = Revenue FX Impact - Cost FX …

@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…

Correct Row Totals but Incorrect Row Totals on Table Matrix

DAX DAX Calculations

Greg July 30, 2020, 11:18am 3

Hi @VincentJT. Another thread that might be of use is the Fix Incorrect Totals post in the DAX Patterns category. Hope this helps. Greg