Average Working Days Divided by two for Part Time Employees

[Anonymous]

Good Day,

I am needing to adjust my Dax formula to divide by two when the employee is Kennedee Lantis. Can someone lend me a hand?

Per Day Average = CALCULATE(Audit[SUM pro/job Audits & Entries]/MAX('Working Days'[Working Days]) + 0)

Many thanks,

Lydia

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

Per Day Average =
VAR Result =
    CALCULATE (
        DIVIDE ( [SUM pro/job Audits & Entries], MAX ( 'Working Days'[Working Days] ) ) + 0
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Name] ) = "Kennedee Lantis",
        DIVIDE ( Result, 2 ),
        Result
    )