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] )
    )
)
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi WLFRD ,

 

You can directly drag your partnumber and Quantity column then mark Quantity column summerization as Sum.

 

 

Thanks,

Samarth

 

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.