Power Matrix - getting %'s showing correctly in totals

[Anonymous]

Hi I have a matrix that shows the number of hours each month that a user is available to work and the number that they are actually working based on jobs allocated to them 

The matrix has a calculated column (Util) based on Working Hours / Available Hours which all works correctly - however the totals whilst summing the working & available hours , doesnt then calculate the total util of total working hours / total available hours - I only have the option of havingb the sum of the utils or the average of the utils - which is not the correct answer - I attach the table of data & the matrix - plus the same visual in an excel piviot table which calculates the total util correctly

BI Table

Power BI Matrix

Pivot table 

A Power BI newbie , so any help gratefully appeciated !

Thanks

Paul

[jdbuchanan71 · Accepted solution]

@Anonymous 

You should do the calcualtions with measures, rather than a calculated column.  Add 2 measures to sum up the available and working hours.

Available Hours = SUM ( 'YourTable'[available] )

Working Hours = SUM ( 'YourTable'[working] )

Then a measure to use those first two and calcualte the Utilization

Utilization = DIVIDE ( [Working Hours], [Available Hours], 0 )

[Anonymous]

Thanks - that works !