Forum Discussion
Calculate utilisation percentage
I am trying to put the team utilisation in power bi.
issue when i tried to calculate percentage is showing the total percentage which is incorrect. Just wanted to show percentage by team, activity type and employee name. here is the link to sample data formate that i have. Appreciate the help
https://drive.google.com/file/d/1CpJ4gz1HaKdfUcXWxWLoQ-epnkygp8T6/view?usp=drivesdk
2 Replies
- amitchandak
Super User
Adhvaith , Try Visual calculation.
There is template for % of Total
Visual Calculations in Power BI- February 2024 Update RUNNINGSUM, RANGE, MOVINGAVERAGE, COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL, FIRST, LAST, PREVIOUS, and NEXT
https://www.youtube.com/watch?v=bKD9T0EWgQo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8LI did a try as below but the grand total is showing the sum of average.
Core Production Utilization % =
IF(
ISINSCOPE('YourTableName'[Date]),
-- Calculate daily utilization percentage
VAR DailyCoreProductionMinutes =
CALCULATE(
SUM('YourTableName'[Time]),
'YourTableName'[Activity Type] = "Core Production"
)
RETURN
DIVIDE(DailyCoreProductionMinutes, 540, 0) * 100,
-- Calculate overall average utilization percentage
VAR DailyUtilizationTable =
SUMMARIZE(
'YourTableName',
'YourTableName'[Date],
"DailyUtilization",
VAR TotalAvailableMinutes = 540
VAR CoreProductionMinutes =
CALCULATE(
SUM('YourTableName'[Time]),
'YourTableName'[Activity Type] = "Core Production"
)
RETURN
DIVIDE(CoreProductionMinutes, TotalAvailableMinutes, 0) * 100
)
RETURN
AVERAGEX(DailyUtilizationTable, [DailyUtilization])
)
