Forum Discussion

anusha_2023's avatar
anusha_2023
Icon for Helper IV rankHelper IV
2 years ago

Matrix formatting in Power BI

My first question is regarding the count of Project ID: I have a matrix with the Resource name and Resource Role from the resource table, and the ID is from the project table. I drilled down on the r...
anusha_2023's avatar
anusha_2023
Icon for Helper IV rankHelper IV
2 years ago

These are my measure calculations

Booked Hours = sum(bookings[bookedHours])

AvailableTime = sum(bookings[AvailableTime]

utilization_forecast = DIVIDE(sum(bookings[bookedHours]),sum(bookings[AvailableTime]))