Calculate sum of daily average FTE

[abdelkader2]

Hello I'be got one table 'MEMO_TEMPS)  with : date (D_PRODUCTION) area (PLANS.C_COD_PLAN) and team (POINTAGES.C_COD_EQ) and also FTE. I calculated average FTE per day per area and team with this calculation :

FTE2 = sum(MEMO_TEMPS[FTE])/DISTINCTCOUNT(MEMO_TEMPS[D_PRODUCTION])

Data from this calculation are ok but I need to have sum of daily average FTE per area (here it's not ok).

for exemple here 3821 we've got 5.69 but I need to have : 3.53+1.23+1.05+1 =6.83.

Can you please help me ? 

[amitchandak · Accepted solution]

@abdelkader2, not very clear. Test a measure such as

sumx(values(MEMO_TEMPS[plans.c_code_plan]), sum(MEMO_TEMPS[FTE])/DISTINCTCOUNT(MEMO_TEMPS[D_PRODUCTION]))

[abdelkader2]

I try but still same issue