Forum Discussion
Calculate utilisation percentage
Super UserAdhvaith , 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=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
I 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])
)