Forum Discussion

ahiemstra's avatar
ahiemstra
Icon for Helper I rankHelper I
2 years ago
Solved

Calculate Average FTE based on Distinct Employee IDs in Another Column

I’m looking for some help with a measure. I have a table where column A lists Employee ID and column B lists the employee's Full-Time Equivalent (FTE). Each employee is listed in the table multiple t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Write these 2 measures and drag the second one to the visual

    Avg FTE = AVERAGE(Data[FTE])
    Avg FTE1 = SUMX(VALUES(Data[Employee ID]),[Avg FTE])

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Write these 2 measures and drag the second one to the visual

Avg FTE = AVERAGE(Data[FTE])
Avg FTE1 = SUMX(VALUES(Data[Employee ID]),[Avg FTE])

Hope this helps.