One Matrix for different metrics

[amirghaderi]

I need to create the below matrix data from available data that I have. But, I am not sure how it can be done in one table view since the row grouping is not one consistant group.

Project	Budget	Actual	Code1	Code2	Code3
A100	150	190	C	AA	Assess
A100	200	150	B	BB	Assess
A100	200	180	C	AA	Select
A100	122	180	B	BB	Select
A100	300	200	B	BB	FEED
A100	260	179	D	CC	FEED
A200	250	300	B	CC	Select
A200	135	166	C	BB	Select
A200	185	179	C	BB	Assess

Expected output

Filter by Project	A100
	Assess	Assess	Assess	Select	Select	Select	FEED	FEED	FEED
	Input1	Input2	Metric	Input1	Input2	Metric	Input1	Input2	Metric
Total Budget (Input1) to Actual (Input2) Project Cost	$                  350	340	350/340	322	360	322/360	560	379	560/379
Total Actual Code1 C (Input1)  to Total Actual Code1 B (Input 2)	190	150	190/150	180	180	180/180	0	180	0/180
Total Actual Code 2 BB (Input1) to Total Actual Cost (Input 2)	150	340	150/340	180	360	180/360	200	379	200/379

[v-yiruan-msft · Accepted solution]

Hi @amirghaderi ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

1. Create a measure as below

Metric =
DIVIDE (
    CALCULATE ( SUM ( 'Table'[Budget] ) ),
    CALCULATE ( SUM ( 'Table'[Actual] ) )
)

2. Create a matrix visual (Rows: Project  Columns: Code3  Values: Budget, Actual and New measure)

Best Regards