Forum Discussion
WLFRD
Helper III
4 years agoSum 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...
- 4 years ago
oh okay WLFRD , then try this:-
Column = CALCULATE ( SUM ( 'ProductionPartAll'[Quantity] ), FILTER ( 'ProductionPartAll', 'ProductionPartAll'[PartNumber] = EARLIER ( 'ProductionPartAll'[PartNumber] ) ) )
vanessafvg
Community Champion
4 years agowhat result are you getting? can you share?
I get this result from your measure
WLFRD
Helper III
4 years agoThis is my result in Power BI:
| PartNumber | Total_QTY_Per_PartNumber |
| 128544 | 405 |
| 658745 | 207 |
| 238574 | 198 |
| 254152 | 99 |
| 128588 | 81 |
| 123659 | 63 |
| 598749 | 45 |
| 254875 | 36 |
| 112455 | 18 |
| 124588 | 18 |
| 158965 | 9 |