Regionwise Allocation vs Available hours

[yarlachiranjeevi]

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 rows 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

Sample.pbix

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Regionwise Allocation vs Available hours
and Regionwise Allocation vs Available hours Power BI
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[yarlachiranjeevi]

i have posted this in other forums

Regionwise Allocation vs Available hours

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...

www.mrexcel.com

Regionwise Allocation vs Available hours Power BI

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...

www.excelforum.com

 

[RoryA]

There is no need to repeat the link(s) provided above

@yarlachiranjeevi Please note that above part.
Also, one of the links you posted is actually to this thread, not to the one you posted on Chandoo.