Forum Discussion

Sharksguts's avatar
Sharksguts
Frequent Visitor
7 years ago
Solved

Labour Efficiency

How can you calculate the labour efficiency from a table of labour bookings? See example data and required results below.   The problem I am having is the production standard is per Job Num/Asm/Ope...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Sharksguts,

     

    You may add the following measures.

    Measure Production Std =
SUMX (
    SUMMARIZE (
        Table1,
        Table1[Job Num],
        Table1[Asm Seq],
        Table1[Op Seq],
        Table1[Op Code]
    ),
    CALCULATE ( MAX ( Table1[Production Std] ) )
)

    Measure Labour Hrs =
SUM ( Table1[Labour Hrs] )

    Measure Efficiency =
DIVIDE ( [Measure Production Std], [Measure Labour Hrs] )
ssugar's avatar
ssugar
Icon for Resolver III rankResolver III
7 years ago

 

Go to the Query Editor, select the Job Num, Asm Seq, Op Seq, and Op Code columns, and hit the Group By button.

Then in the Aggregations area use the following columns and operations:
Production Std - Min
Labour Hours - Sum
Required Qty - Sum
Completed Qty - Sum

 


That will get you the table you're looking for.  Then you can just divide production std by labour hours to get your efficiency.

Let me know if you need any further help.

  • Sharksguts's avatar
    Sharksguts
    Frequent Visitor
    7 years ago

    Hi SSugar

     

    That definitely helped me understand Power Bi more.

     

    I could group the data and that would fix my problem, however, the measure suggested below would allow me to drill down.

     

    Thanks for your help.

     

    Richard