DAX Utilization % - Measure Formula

Question

How can I perform calculation %Utilization DAX and I am finding hard to figure out the formula

How can I perform this?

Answer 1

Use the following measures

[hours available]:=SUMX(DISTINCT(timesheet[resource_key]),CALCULATE(SUM(calendar[utility_hours]),FILTER('calendar',calendar[date_key]>=FIRSTDATE(resources[hire_date_key])),FILTER('calendar',calendar[date_key]<=LASTDATE(resources[termination_date_key]))))

[hours available]:=SUMX(resources,CALCULATE(SUM(calendar[utility_hours]),FILTER('calendar',calendar[date_key]>=FIRSTDATE(resources[hire_date_key])),FILTER('calendar',calendar[date_key]

<=LASTDATE(resources[termination_date_key])))) 

[hours charged]:=SUM(timesheet[bill_hours])+0 

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification