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

what result are you getting?  can you share?

 

I get this result from your measure

 

 

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

    This is my result in Power BI:

     

    PartNumberTotal_QTY_Per_PartNumber
    128544405
    658745207
    238574198
    25415299
    12858881
    12365963
    59874945
    25487536
    11245518
    12458818
    1589659

     

     

  • 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.