I'm using the Power BI content pack for PWA data and am trying to calculate monthly FTE using hours currently assigned to resources "assignment work". Under the TimeSet table I have written two measures which calculate working days per month and working hours based on an 8 hour working day.
Working Hours = TimeSet[Working Days]*8
Working Days = CALCULATE(COUNTA(TimeSet[TimeByDay]),TimeSet[Is Working Day]="yes")
Now I want to divide Assignment Work by Working Hours to calculate the FTE but the Assignment Work is in AssignmentTimePhaseDataSet and I don't know what DAX formula I need.