Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Grouping data & sum negatives

Hi   I have a table of Categoies (made up of Items), Weeks, Sites & a Value assigned to each.   Category Item Week Site Value C1 I1 W1 S1 7 C1 I1 W1 S2 3 C1 I1 W2 S1 -...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous 

 

or this one

 

Measure 2 =
SUMX (
    FILTER (
        SUMMARIZE ( Table1, Table1[Category], "Sum", SUM ( Table1[Value] ) ),
        [Sum] < 0
    ),
    [Sum]
)