Forum Discussion

pak's avatar
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 MACH...
  • Mariusz's avatar
    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