Measure to calculate Full-time equivalent (FTE)

[Bfaws]

Hi,

I was hoping someone could help.  I`m pretty new to DAX and I`m struggling with a measure.  I`m trying to figure out two figures based a a list of employees and report dates.  I need to essentially know how many actual employees we have in a single month as well as what the full time equivalent (FTE) is for that month. I have managed to figure out the actual count of employees but it is the full time equivalent that I`m struggling with. 

This here is what the table looks like:

and this is the expected result:

Any help would be much appreciated.

Thanks.

[AlB]

Hi @Bfaws 

Would this not be sufficient?

       Measure = SUM(Table1[FTE])

where Table1 is the first table you show

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[stevedep · Accepted solution]

Seem like you want to do a count and a sum?

Nothing special needed in that case. Just set the calculation to sum in the values part of the table. 

See;

Power BI file available here.

Please mark as solution if this is what you are looking for.

Kind regards,

Steve.