Measure grand totals don't equal the sum of row-by-row column t

Hi Jens,

I hope you are well. I have an urgent issue with our Power Bi Model that I would appreciate support on.

I am using a measure, and I am having an issue where the sum of the rows in a table don't match the grand total value at the end for a Dax measure, when the measure multiplies two columns together.

I understand from reading online this is a fundamental issue with Power BI.

I have also seen and tried using the summarize function to fix the grand totals, however, then the individual row values are incorrect.

There is a possible workaround- having one column where the "row-to-row" values are correct, and have another column where only the grand total value is correct for the same calculation. However, I was wondering if there's a solution to having all the values correct in one column.

For context, we want to have a measure where the values are dependent on a set of filters. We want to do this in several different tables. We then want to sum all these different measures together in a final table.

As this is quite an urgent issue, could we please arrange a meeting early next week on how best to do this?

Thanks,
Ben