Wierd measure calcualtion when exporting data
This is my measure: FTE Norm Timeloen = AVERAGEX ( VALUES ( DimDato[MånedÅr] ), CALCULATE([Arbejds-timer i perioden] / 162.5 , FILTER(DimJob, DimJob[Ansættelsesform] = "Timelønnede")) ) It works nicely for month in a year and also when I show for Year total: december as an example works fine, so when I see the result 21.276 it adds up for the data when I extract to excel. When I show year only it gives me: The 23.878 i currectly an average of hours 46561.6 for the year divided by 162.5 But here is the odd thing. When I extract the data. the FTE is higher: When I add the FTE together it adds up to 38.65 Hos is that when the month is correct, the average FTE over year is correct, but the FTE when added is higher. What am I missing or is the measure not correct?FTE per employee is correct but not total
My measure works fine on a per employee, but the total is wrong. The measure is this: FTE ny = Var MaxDate = MAX ( DimDato[Dato] ) Var MinDate = MIN ( DimDato[Dato] ) VAR EmpStartDate = MIN ( DimStamdata[Medarbejder startdato] ) VAR EmpEndDate = MAX ( DimStamdata[Medarbejder slutdato] ) VAR MinWorkDate = IF ( EmpStartDate >= MinDate, EmpStartDate, MinDate ) VAR MaxWorkDate = IF ( EmpEndDate <= MaxDate && EmpEndDate <> BLANK() , EmpEndDate, MaxDate ) VAR WorkMthCount = IF ( DATEDIFF(MinWorkDate,MaxWorkDate,MONTH) < 0, BLANK(), DATEDIFF(MinWorkDate,MaxWorkDate,MONTH) + 1) VAR MonthVarCount = DATEDIFF ( MinDate, MaxDate, MONTH ) RETURN ([Arbejdstid] / 37.5) * ( WorkMthCount / (MonthVarCount + 1 ) ) Arbejdstid is working hours per week, and the result: FTE ny is my measure that correctly calculates the FTE over full year, were employee 9304 has been hired for only 2 month giving it a 0,17 (2 out of 12 month) FTE count. But the Total 3,67 is not correct, it should be (1 + 1 + 0.67 + 0.17 = 2.84) What am I missing?
