Dax measures total mismatch in visual level

Excellove15 

I'm on

Error you have is explained here

Error - Summarise columns and addmissingitems may not be used in this context power bi - DAX / DAX Calculations - Enterprise DNA Forum

Solved: SummarizeColumns() and AddMissingItems() - Microsoft Fabric Community

Introducing SUMMARIZECOLUMNS - SQLBI

In brief, we need to avoid SUMMARIZECOLUMNS() in measures and use SUMMARIZE() instead. Have no idea why there is no error in my case.

Anyway, I updated the measure on

Forecast - Target Units_2-new copy =
VAR Actuals =
SELECTCOLUMNS (
    ADDCOLUMNS (
        SUMMARIZE (
            DataInvoice,
            Calendar_[Month-Year],
            Points[DBName-Point_Id],
            "Act", SUM ( DataInvoice[Units] )
        ),
        "ID",
            Calendar_[Month-Year] & "=" & Points[DBName-Point_Id]
    ),
    [ID]
)
    VAR FilterTargets =
    FILTER(
        'Target Timeseries_1',
        NOT ( 'Target Timeseries_1'[ID] IN Actuals )
    )
VAR Targets =
    CALCULATE(
        SUM( 'Target Timeseries_1'[Usage Per Day] ),
        FilterTargets
    )
RETURN
    Targets

Both give the same result

Timing for the updated measure on above visual (without previous measure)

Updated file Portfolio Performance - v2.13 - Update 01.pbix