Sum of numbers does not equal the total

[Greg]

Hi @Hitman.

Have you tried the Fix Incorrect Totals pattern?

Fix Incorrect Totals

When using a measure column in a visual, it is not uncommon in Power BI to find that the totals are incorrect. The Fix Incorrect Totals DAX pattern can be used to correct this issue. When a DAX measure is providing the correct detail value it often, unfortunately, provides an incorrect value for the total row. This is due to there being no evaluation context for the total row. For example, when comparing the [Total Sales] to the [Sales LY] to find the minimum for a customer using the simple DAX…

You may also get some insights from this thread

Count of New & Exited Members by Channel FYTD

Hi @newtopbi. More progress, but not an exact match. To ensure I didn’t use any previous assumptions, I rebuilt the PBIX from scratch, and with @Melissa’s help on the v4 DAX formulae, I’ve come quite close. I’ve highlighted the matched values (exact or very close) in light blue. (There’s an issue [probably small one, but I couldn’t find it quickly] with using the same base code for [Exited Balance] as for [Exited Members], but the technique works for “New”, so …) [eDNA Forum - Count of New &…

Hope this helps.
Greg