CODEWITHSUNDEEP
powerbidaxpowerquerypowerbi-desktoppowerbi-custom-visuals
B.B
B.B

Reputation: 35

Percentage sum by category - Power BI

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

Download PBIX

enter image description here

Thanks you very much.

Upvotes: 1

Views: 1505

Answers (1)

smpa01
smpa01

Reputation: 4282

Try this measure

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

s1

Upvotes: 2

Related Questions