Average per month

Frequent Visitor

3 years ago

to make it bit more clear, here is how I calculate OEE

OEE Average =

VAR _plannedProd = AVERAGE(View_Calendar_ProductionPlan_All[ShiftDuration]) * DISTINCTCOUNT(View_Calendar_ProductionPlan_All[SmenaStart.2]) * 52.5

VAR _DtUnplan = CALCULATE(SUM(View_Calendar_ProductionPlan_All[Eval_Duration]),

View_Calendar_ProductionPlan_All[ActivityCategory_ID] = 2 //Organizacni prostoj

)/60

VAR _ProdTime = _plannedProd - _DtUnplan

VAR _PlannedPcs = SUM(Vyrobni_target[HourTarget]) * (DIVIDE([ProductionTime],60))

VAR _Availability = DIVIDE(_ProdTime, _plannedProd)

VAR _Performance = DIVIDE(SUM(View_Calendar_ProductionPlan_All[Eval_Produced]),_PlannedPcs)

VAR _Oee = _Availability * _Performance

RETURN

_Oee

Forum Discussion