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] )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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] )
Sharksguts's avatar
Sharksguts
Frequent Visitor
7 years ago

Hi Sam

 

Brilliant that worked perfectly thank you for your prompt help.

 

I'm loving Power Bi.

 

Regards


Richard