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...
Need Help
  • Mariusz's avatar
    Mariusz
    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

     

Mariusz's avatar
Mariusz
Community Champion
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