Weighting Utilisation Hours by FTE decimal

Question

hi all,&nbsp;we just got Power BI at work hooray !!, I was trying to use it to do some employee timesheet calcs and I'm stuck, this seeems to have a huge community so i wondered if you could help :-)&nbsp;So&nbsp;&nbsp;I want to find out what employee utilsation is -&nbsp;I have two tables 1 dimension where instances of hours and thier activitiy are recorded and a fact table that contains employee details. the dimension table has an hours column where people enter either 3.7 for a half day or 7.4 for a full day, sometimes there are multiple entries for the same day.&nbsp;&nbsp;I've had no problem adding a conditional column to the fact table based on the type of activity and can get a utilisation %&nbsp; by dividing the total hours by the chargeable hours, but should I be taking peoples FTE hours or ratio into account?, on the person key i have an FTE hours and a ratio column I could use.&nbsp;&nbsp;&nbsp;Is there some dax that could do this complete calc - I'm intermediate level - unfortunately I cant share a file - but i have put some pictures&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

v-huizhn-msft · Answer

Hi&nbsp;Anonymous,What result do you want? Please list expected result, could you please give an example?Best Regards,Angelia

anonymous · Answer

hi Angelia&nbsp;I want to find a % utilsation figure but adjusted for FTE&nbsp;I tried lots of measures but I think I'm missing something&nbsp;I have a measure for total hours TOTHOURS = CALCULATE(SUM([POT[HOURS])&nbsp;&amp; one for chargeable time based on an additional&nbsp;column that marks activity 'chg' or 'nonchg'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHGHOURS = CALCULATE(SUM([POT[HOURS]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(POT,POT[CHG/NONCHG] = "CHG")&nbsp;I get utilisation by dividing one by the other&nbsp;what im unsure about is weather or not I should adjust for the fact that some people are part time, or is it enough that powerbi only sums the entries people make so an adjustment is not required.&nbsp;if I should adjust is there some kind of nested function I could use&nbsp;many thanks for your response&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Weighting Utilisation Hours by FTE decimal

2 Replies

Related content

Decimal Precision

Calculating Weighted Sales

Calculating Weighted Average

remove decimals

Weighted Average DAX