How to calculate FTE

[selected_]

I have a column in that contains data on the percentage of how much an employees work, 1 in the column is consinder to be 100% full timer while  there are employees who work less, like 0,2 , 0,994  as you can see below, in the column there are also 1 which is consider to be a fulltimmer employee with 100% . I want to calculate the total number of full-time employees, meaning that, for example, 5 employees each working at 0,2 can collectively represent one 100% full-time equivalent. How can I do this in DAX?

I have a column named 'fte' and 'employeeid'."

[rsbin · Accepted solution]

@selected_ ,

Simply create a Measure to SUM your 'FTE' column:

FTEEquivalent = SUM(YourTable[FTE] )

FTE

1
0.2
0.2
0.2
0.2
0.2

I trust this is what you are looking for.

Regards,