Forum Discussion

Claudine's avatar
Claudine
Regular Visitor
6 years ago
Solved

Summing a Column Grouped by Value in Another Column

Hello,    I'm trying to do a simple sumif (simple in Excel that is) but can't seem to make it work Power BI   If I have the sample table below (simplified for this sample but actual data has mult...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    Thanks for the data.

    Adding the dimension table to the allexcept clause should get the correct result.

    Something like

    CALCULATE(SUM(TableA[ONHANDQTY]), ALLEXCEPT(TableA, TableA[ITEMID], TableB))
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

Thanks for the data.

Adding the dimension table to the allexcept clause should get the correct result.

Something like

CALCULATE(SUM(TableA[ONHANDQTY]), ALLEXCEPT(TableA, TableA[ITEMID], TableB))
Claudine's avatar
Claudine
Regular Visitor
6 years ago

Thank you very much HotChilli !