Hello, I want to calulate performance for machines. I got this data:TimeMachineQuantityWorkTimePlanned1PcTime2020-04-28 16:16:08MACHINE-100482020-04-28 16:16:08MACHINE-200602020-04-28 16:16:08MACHINE-300202020-04-28 16:16:08MACHINE-400902020-04-28 16:16:39MACHINE-100.4482020-04-28 16:16:39MACHINE-202.6602020-04-28 16:16:39MACHINE-302202020-04-28 16:16:39MACHINE-401.2902020-04-28 16:17:09MACHINE-1030.2482020-04-28 16:17:09MACHINE-2030.2602020-04-28 16:17:09MACHINE-3020202020-04-28 16:17:09MACHINE-4030.2902020-04-28 16:17:40MACHINE-1030.2482020-04-28 16:17:40MACHINE-2030.2602020-04-28 16:17:40MACHINE-3116.2202020-04-28 16:17:40MACHINE-4030.2902020-04-28 16:18:11MACHINE-1030.2482020-04-28 16:18:11MACHINE-2124602020-04-28 16:18:11MACHINE-305.8202020-04-28 16:18:11MACHINE-4121.2902020-04-28 16:18:41MACHINE-1117.6482020-04-28 16:18:41MACHINE-2030.2602020-04-28 16:18:41MACHINE-3022202020-04-28 16:18:41MACHINE-4030.2902020-04-28 16:19:12MACHINE-1030.2482020-04-28 16:19:12MACHINE-2014.4602020-04-28 16:19:12MACHINE-3122202020-04-28 16:19:12MACHINE-4030.2902020-04-28 16:19:43MACHINE-1030.2482020-04-28 16:19:43MACHINE-2121602020-04-28 16:19:43MACHINE-3113.6202020-04-28 16:19:43MACHINE-4030.2902020-04-28 16:20:13MACHINE-1020.2482020-04-28 16:20:13MACHINE-2030.2602020-04-28 16:20:13MACHINE-3116.6202020-04-28 16:20:13MACHINE-4030.2902020-04-28 16:20:44MACHINE-1129.2482020-04-28 16:20:44MACHINE-2117.4602020-04-28 16:20:44MACHINE-3013.8202020-04-28 16:20:44MACHINE-4123.8902020-04-28 16:21:15MACHINE-1030.2482020-04-28 16:21:15MACHINE-2030.2602020-04-28 16:21:15MACHINE-3122202020-04-28 16:21:15MACHINE-4030.2902020-04-28 16:21:45MACHINE-1030.2482020-04-28 16:21:45MACHINE-2030.2602020-04-28 16:21:45MACHINE-317.8202020-04-28 16:21:45MACHINE-4030.290 It's ok when filter is set to one of the machines. But when i want to see performance for all machines, it's wrong, because Planned1PcTime is different for every machine. It should count performance for each meachine and then count average for those machines performance - in this case: sum of average performance for every machine (seperately) devide by 4(machines). I want to shaw data in line chart in time bins (for this example 2 minutes).I've tried many ways mentioned in other posts but nothing works correctly.I'm sending data from devices every 15 secounds.General formula for performance is: PerformanceAVG = (SUM(Table[Quantity])*AVERAGE(Table[Planned1PcTime]))/SUM(Table[WorkTime]) Overall:Machine-1 Performance = 34,43%Machine-2 Performance = 69,07%Machine-3 Performance = 74,17%Machine-4 Performance = 62,54%Performance for all machines should be 60,05% NOT 71,64%. I'll be gratefull for any help 🙂

pak

Helper II

6 years ago

Solved

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	MACHINE-2	0	0	60
2020-04-28 16:16:08	MACHINE-3	0	0	20
2020-04-28 16:16:08	MACHINE-4	0	0	90
2020-04-28 16:16:39	MACHINE-1	0	0.4	48
2020-04-28 16:16:39	MACHINE-2	0	2.6	60
2020-04-28 16:16:39	MACHINE-3	0	2	20
2020-04-28 16:16:39	MACHINE-4	0	1.2	90
2020-04-28 16:17:09	MACHINE-1	0	30.2	48
2020-04-28 16:17:09	MACHINE-2	0	30.2	60
2020-04-28 16:17:09	MACHINE-3	0	20	20
2020-04-28 16:17:09	MACHINE-4	0	30.2	90
2020-04-28 16:17:40	MACHINE-1	0	30.2	48
2020-04-28 16:17:40	MACHINE-2	0	30.2	60
2020-04-28 16:17:40	MACHINE-3	1	16.2	20
2020-04-28 16:17:40	MACHINE-4	0	30.2	90
2020-04-28 16:18:11	MACHINE-1	0	30.2	48
2020-04-28 16:18:11	MACHINE-2	1	24	60
2020-04-28 16:18:11	MACHINE-3	0	5.8	20
2020-04-28 16:18:11	MACHINE-4	1	21.2	90
2020-04-28 16:18:41	MACHINE-1	1	17.6	48
2020-04-28 16:18:41	MACHINE-2	0	30.2	60
2020-04-28 16:18:41	MACHINE-3	0	22	20
2020-04-28 16:18:41	MACHINE-4	0	30.2	90
2020-04-28 16:19:12	MACHINE-1	0	30.2	48
2020-04-28 16:19:12	MACHINE-2	0	14.4	60
2020-04-28 16:19:12	MACHINE-3	1	22	20
2020-04-28 16:19:12	MACHINE-4	0	30.2	90
2020-04-28 16:19:43	MACHINE-1	0	30.2	48
2020-04-28 16:19:43	MACHINE-2	1	21	60
2020-04-28 16:19:43	MACHINE-3	1	13.6	20
2020-04-28 16:19:43	MACHINE-4	0	30.2	90
2020-04-28 16:20:13	MACHINE-1	0	20.2	48
2020-04-28 16:20:13	MACHINE-2	0	30.2	60
2020-04-28 16:20:13	MACHINE-3	1	16.6	20
2020-04-28 16:20:13	MACHINE-4	0	30.2	90
2020-04-28 16:20:44	MACHINE-1	1	29.2	48
2020-04-28 16:20:44	MACHINE-2	1	17.4	60
2020-04-28 16:20:44	MACHINE-3	0	13.8	20
2020-04-28 16:20:44	MACHINE-4	1	23.8	90
2020-04-28 16:21:15	MACHINE-1	0	30.2	48
2020-04-28 16:21:15	MACHINE-2	0	30.2	60
2020-04-28 16:21:15	MACHINE-3	1	22	20
2020-04-28 16:21:15	MACHINE-4	0	30.2	90
2020-04-28 16:21:45	MACHINE-1	0	30.2	48
2020-04-28 16:21:45	MACHINE-2	0	30.2	60
2020-04-28 16:21:45	MACHINE-3	1	7.8	20
2020-04-28 16:21:45	MACHINE-4	0	30.2	90

It's ok when filter is set to one of the machines. But when i want to see performance for all machines, it's wrong, because Planned1PcTime is different for every machine. It should count performance for each meachine and then count average for those machines performance - in this case: sum of average performance for every machine (seperately) devide by 4(machines). I want to shaw data in line chart in time bins (for this example 2 minutes).
I've tried many ways mentioned in other posts but nothing works correctly.

I'm sending data from devices every 15 secounds.
General formula for performance is:

PerformanceAVG = (SUM(Table[Quantity])*AVERAGE(Table[Planned1PcTime]))/SUM(Table[WorkTime])

Overall:

Machine-1 Performance = 34,43%

Machine-2 Performance = 69,07%

Machine-3 Performance = 74,17%

Machine-4 Performance = 62,54%

Performance for all machines should be 60,05% NOT 71,64%.

I'll be gratefull for any help 🙂

Need Help

Mariusz

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

Forum Discussion

Calculate Performance by group (machine)

3 Replies

Related content

Machine Learning Prophet Issues

DAX performance optimization

Calculating delivery performance

DAX Performance

Fabric Pipeline Performance