Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Efficiency Calculation + Relationship

Hello,   I been trying to create a computation of our company efficiency and I am really stuck on this. Not sure if my relationship of table are correct or maybe the solution is just simple and Im...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Not tested on your file. This is something that can be tried 

Box Count = Sum('Box Table','Box Table'[Box Count])

Sum Minute = Sum('Box Table','Box Table'[Minute])


Box Per Min = sumx('Box Table' ,Divide('Box Table','Box Table'[Box Count],'Box Table'[Minute]))

Or 
Box Per Min = sumx('Box Table' ,Divide(sum('Box Table','Box Table'[Box Count]),Sum('Box Table'[Minute])))

Efficiency =
AverageX(summarize ('Order Details','Order Details'[Line],Conversion[Convertion],'Efficiency Table'[Machine],'Efficiency Table'[Target],"_box",[Box Per Min ])
, divide([_box],(Divide([Target],[Convertion])*[Machine])))


Efficiency =
AverageX(summarize ('Order Details','Order Details'[Line],Conversion[Convertion],'Efficiency Table'[Machine],'Efficiency Table'[Target],"_box",[Box Count],"_min",[Sum Minute])
, divide([_box],(Divide([Target],[Convertion])*[Machine]*[_min])))