Calculating Delta of many parameters and Show in The Matrix

[billysagala]

Hi All, 

Hi All.

Asking for help from you. 

I would like to have a Comparison Table using Matrix on PowerBI of Actual VS Budget. The aim is to know the difference between Actual and Budget from each Component Delta = (Amount of Actual) - Amount of Budget, also Delta Percentage = Delta / Budget.

This is the dummy dataset on Excel:

Name	A	B	C	D	E	F	TAG
XY	1	3	1	2	1	2	Actual
YZ	1	2	2	2	2	3	Actual
XY	2	2	1	3	3	2	Budget
YZ	1	2	1	2	2	1	Budget

This is what we have in powerBI Matrix:

How can i add The Delta and Delta Percentage instead of Total? The aim is to have both on the same column for every row.

Thank you for your kind help.

[V-pazhen-msft · Accepted solution]

@billysagala 

You may create measure instead of using column value:

After unpivot the A to F columns, you may create following measures.

actual = CALCULATE(SUM('Table'[Value]),FILTER('Table',[TAG]="Actual"))

budget = CALCULATE(SUM('Table'[Value]),FILTER('Table',[TAG]="Budget"))

delta = [actual] - [budget]

delta% = [delta] / [budget]

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[billysagala]

UP UP