Multiple calculations in a Measure

[Anonymous]

Hello,

Can anyone correct the last line of my DAX formula?

var Work_Days = 
CALCULATE(
    DISTINCTCOUNT('July 2021'[Date]),
    FILTER(
        'July 2021',
        'July 2021'[Time code] <> "PH"
            && WEEKDAY('July 2021'[Date],2) < 6
    ))
VAR WFW = SUMX(FILTER('July 2021','July 2021'[Project Name]="WFW"), 'July 2021'[Hours])
VAR emp_count = DISTINCTCOUNT('July 2021'[Employee Name])
RETURN
    (((emp_count * Work_Days * 8.5) - WFW)/ emp_count * Work_Days * 8.5)

[amitchandak · Accepted solution]

@Anonymous , what is the issue you are facing

try like

RETURN
divide(((emp_count * Work_Days * 8.5) - WFW), emp_count * Work_Days * 8.5)