Forum Discussion
pak
6 years agoHelper II
Calculate Performance by group (machine)
Hello, I want to calulate performance for machines. I got this data: Time Machine Quantity WorkTime Planned1PcTime 2020-04-28 16:16:08 MACHINE-1 0 0 48 2020-04-28 16:16:08 MACH...
- 6 years ago
Hi pak
Try this
Measure = AVERAGEX( VALUES( 'Table'[Machine] ), CALCULATE( DIVIDE( SUMX( 'Table', 'Table'[Quantity] * 'Table'[Planned1PcTime] ), SUM( 'Table'[WorkTime] ) ) ) )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn