Matrix tile - custom data alignment

[Anonymous]

Hello everyone, 

I'm working on a new project where management wants to evaluate the how a resource is being utilized on a monthly basis. They have determined that any one resource has 174 available work hours per month and supervisors assign # work hours to tasks on a monthly basis. They want to see if resources are being over or underassigned work per month.

Data Set

WorkCategory	ProjectNameId	TierOrg	Resource Role	REsourceNameId	TaskDetail	Date	Commit Hours	Capacity Hours
Project	A25	2	BA Resource	85224	Reporting Analyst	11/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	10/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	9/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	8/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	7/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	6/1/2020	150	174
Project	A25	2	BA Resource	85224	Reporting Analyst	5/1/2020	160	174

I'm putting this into a matrix tile, results:

Date	7/1/2020		8/1/2020		9/1/2020		10/1/2020		11/1/2020		12/1/2020
Resource Name	Commit Hours	Available Hours	Commit Hours	Available Hours	Commit Hours	Available Hours	Commit Hours	Available Hours	Commit Hours	Available Hours	Commit Hours	Available Hours
Dutt,I	150	24	150	24	150	24	150	24	150	24	150	24
Project	150	24	150	24	150	24	150	24	150	24	150	24
Reporting Analyst	150	24	150	24	150	24	150	24	150	24	150	24
Total	150	24	150	24	150	24	150	24	150	24	150	24

I"m trying to get the matrix visual to appear as follows:

Name	Work Category	7/1/2020	8/1/2020	9/1/2020	10/1/2020	11/1/2020	12/1/2020
Dutt, I	Capacity	174	174	174	174	174	174
	Project	160	160	160	160	160	160
	Total	160	160	160	160	160	160
	Available Hours	14	14	14	14	14	14

Any suggestions are appreciated,

ixdutt

[v-xuding-msft]

Hi @Anonymous ,

Can the option of "Show on rows" help you? 

The data in your expected result is not same as your original sample table. If you still need help, can you please share more details with us?

[Greg_Deckler]

@Anonymous - I have a whole recipe on utilization in my book, DAX Cookbook. It's recipe 1 in Chapter 8. Might give you some ideas.

https://github.com/gdeckler/DAXCookbook