Forum Discussion

WLFRD's avatar
WLFRD
Helper 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] )
    )
)
Samarth_18's avatar
Samarth_18
Community 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
Helper 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.