Percentage sum by category - Power BI

Question

How can acheive correct SUM % please? I have attahed PBIX file with data and example:

Download PBIX

Thanks you very much.

Answer 1

Try this measure

Measure2 =
SUMX (
    ADDCOLUMNS (
        CROSSJOIN ( 'Calendar', 'Product Group' ),
        "diff", [Percentage Diff]
    ),
    [Percentage Diff]
)