Forum Discussion

WLFRD's avatar
WLFRD
Icon for Helper III rankHelper III
4 years ago
Solved

Sum quantity per partcode

Hello,   I'm struggling with the sum of quantities per partnumber. Our machines have framenumbers and those machines are build with parts. I would like to sum the parts in an overview. This is the...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    oh okay WLFRD , then try this:-

    Column =
CALCULATE (
    SUM ( 'ProductionPartAll'[Quantity] ),
    FILTER (
        'ProductionPartAll',
        'ProductionPartAll'[PartNumber] = EARLIER ( 'ProductionPartAll'[PartNumber] )
    )
)
WLFRD's avatar
WLFRD
Icon for Helper III rankHelper III
4 years ago

Thanks! But I would like to have a calculated column. I need this total column for another calculation.

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

oh okay WLFRD , then try this:-

Column =
CALCULATE (
    SUM ( 'ProductionPartAll'[Quantity] ),
    FILTER (
        'ProductionPartAll',
        'ProductionPartAll'[PartNumber] = EARLIER ( 'ProductionPartAll'[PartNumber] )
    )
)
  • WLFRD's avatar
    WLFRD
    Icon for Helper III rankHelper III
    4 years ago

    Is it possible to make the calculation dynamic? I mean, based on how we filter the data, it has to calculate the sum per PartNumber.