Regionwise Allocation vs Available hours

yarlachiranjeevo · Oct 31, 2023

in my power bi matrix table , i have employee in rows, allocation hours in columns, columns examples are North, South, East, West and total column. I have a available hours column as well. But the available hours are only available at total level i dont have region level information. What i want to achieve is have a row for employees and in the region columns show allocation hours in one value and (Allocation hours for North/Total available hours), (Allocation hours for South/Total available hours), (Allocation hours for East/Total available hours), (Allocation hours for West/Total available hours) and finally in the grand total column (total allocation hours/total available hours).

i dont have region columns separately all the regions are coming from single column in the table

i want each region hours and percentage to be shown differently. For example Row No-1 , Employee A, North Hours - 20, North % utilization (20/100=20%), South Hours-30, South % Utilization (30/100=30%), East hours -40, East % Utilization - (40/100=40%) , West hours - 10, West % Utilization (10/100=10%) and finally total allocation hours 100, total available hours 100, total utilization % 100%

Also, i cant bring available hours and allocation hours together in one table, because allocation for a week is split into different rwos because multiple projects are there. But available hours should be in single row only, if i bring available hours to combined table, available hours will be duplicated in to multiple rows

How do i achieve this

https://we.tl/t-paNqGPfMlY

yarlachiranjeevo · Oct 31, 2023

i have also posted this in other forums