Sum based on another value

HI Anonymous,

I'd like to suggest you add a variable to summary these records and use the iterator function(sumx) on this variable to apply second aggregations.

Measure =
VAR summary =
    SUMMARIZE (
        Table,
        [Month],
        "Diff",
            LOOKUPVALUE ( RawTable[Target], RawTable[VALUES], [Month] )
                - LOOKUPVALUE ( RawTable[Target], RawTable[VALUES], "Total " & [Month] )
    )
RETURN
    SUMX ( summary, [Diff] )

The 'table' is a new calculate table with all month names, they are used as the category of table visual.

Regards,

Xiaoxin Sheng