Calculation of Overtime Average

[tierrak]

Hello,

I have Column A that has types of Hours Worked, (Regular, Overtime, PTO) and Column B that has the total number (55, 15, 8 10). I need to figure out the average amout of Overtime worked divided by the total hours worked. Let me know if the questions is clear.

Column A    Column B

Regular          40

PTO               32

Overtime       16

Overtime        32

Regular         8

PTO             40

PTO             40

Regular        40

Overtime      24

PTO             4

Regular       36

Basically, how do I get the "Card" option to display 23%?

[dedelman_clng · Accepted solution]

I don't think you mean average.  To get 23% you want the total OT divided by the total of all hours

MeasureA =
DIVIDE (
    CALCULATE ( SUM ( OT[Column B] ), OT[Column A] = "Overtime" ),
    CALCULATE ( SUM ( OT[Column B] ) ),
    0
)

Hope this helps

David

[tierrak]

Thank you so much!!!

[tierrak]

Basically, how do I get the "Card" option to display 23%?