Cannot get the sum as expected - Mismatch of date data

[PBI_newuser]

Hi, I couldn't get the sum as expected when suming up the monthly values. Here is the sample.

For example, for Product E, the [Volume Impact] for each month is correct. But when it sum up for FY2020, it became incorrect. It should be -28022 instead of -13369. I couldn't locate the error. Anyone can help me? Thanks.

Volume Impact =
IF (
    MIN ( 'Calendar'[Date] ) > MAX ( 'Append Table'[Date] ),
    CALCULATE (
        SUMX (
            SUMMARIZE ( 'Append Table', 'Calendar'[YearMonth] ),
            IF (
                [Volume Last Year] <= 0,
                ( [Revenue Current Year] - [Revenue Last Year] ),
                ( [Volume Current Year] - [Volume Last Year] ) * [AUSP Last Year]
            )
        ),
        SAMEPERIODLASTYEAR ( 'Calendar'[Date] )
    )*-1,
    SUMX (
        SUMMARIZE ( 'Append Table', 'Calendar'[YearMonth] ),
        IF (
            [Volume Last Year] <= 0,
            ( [Revenue Current Year] - [Revenue Last Year] ),
            ( [Volume Current Year] - [Volume Last Year] ) * [AUSP Last Year]
        )
    )
)

[DataInsights · Accepted solution]

@PBI_newuser,

Try this measure:

Volume Impact Total = SUMX ( VALUES ( 'Calendar'[YearMonth] ), [Volume Impact] )