topic Re: Measure to calculate Full-time equivalent (FTE) in DAX Commands and Tips

Measure to calculate Full-time equivalent (FTE)

Bfaws — Tue, 02 Jun 2020 06:21:47 GMT

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.

Re: Measure to calculate Full-time equivalent (FTE)

stevedep — Tue, 02 Jun 2020 06:41:20 GMT

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.

Re: Measure to calculate Full-time equivalent (FTE)

AlB — Tue, 02 Jun 2020 06:42:54 GMT

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