Total is wrong for DIVIDE function

Anonymous,

Try splitting the measure into two measures: one measure to do the calculation, and a second measure to calculate totals. The base measure is named "Calc", and the totals measure has the original name. In the totals measure (SUMX), you might need to iterate a column with both fiscal_year_nbr and fiscal_month_nbr (e.g., 202202), instead of just fiscal_month_nbr.

LostRevYTDSum Calc =
VAR YTDFiscalMonthNbr =
    IF (
        CALCULATE (
            MAX ( 'Calendar'[fiscal_month_nbr] ),
            'Calendar'[calendar_date] = TODAY ()
        ) = 1,
        12,
        (
            CALCULATE (
                MAX ( 'Calendar'[fiscal_month_nbr] ),
                'Calendar'[calendar_date] = TODAY ()
            ) - 1
        )
    )
VAR SalesLast24M =
    CALCULATE (
        SUM ( ParentPartnerMonthlySales[NetSales] ),
        CALCULATETABLE (
            DATESINPERIOD (
                'Calendar'[calendar_date],
                MAX ( PartnerDates[ParentLostCustomerDate] ),
                -24,
                MONTH
            ),
            USERELATIONSHIP ( PartnerDates[fiscal_month_end_date], FiscalMonthEndDate[fiscal_month_end_date] )
        )
    )
VAR NumOfNonZeroMonths =
    CALCULATE (
        COUNT ( ParentPartnerMonthlySales[FiscalMonthEndDate] ),
        CALCULATETABLE (
            DATESINPERIOD (
                'Calendar'[calendar_date],
                MAX ( PartnerDates[ParentLostCustomerDate] ),
                -24,
                MONTH
            ),
            USERELATIONSHIP ( PartnerDates[fiscal_month_end_date], FiscalMonthEndDate[fiscal_month_end_date] ),
            NOT ( ISBLANK ( ParentPartnerMonthlySales[NetSales] ) )
        )
    )
RETURN
    DIVIDE ( SalesLast24M, NumOfNonZeroMonths ) * YTDFiscalMonthNbr / -1

LostRevYTDSum =
SUMX ( VALUES ( 'Calendar'[fiscal_month_nbr] ), [LostRevYTDSum Calc] )