How to calculate grand difference (similar to grand total) in matrix view

[SaranyaDurairaj]

Hi Members,

I'm working on a requirement that demands grand difference (similar to grand total) in matrix view.

How to acheive difference column that is in red font below. I tried matrix view and I was able to get result except for difference column. Appreciate if there is a better way to acheive this. Thanks!

Dataset: Table1

date	revenue	qty	orders
1/1/2018	100	1	1
1/2/2018	101	1	2
1/3/2018	102	1	3
1/4/2018	103	1	4
1/5/2018	104	1	5
1/6/2018	105	1	6
1/7/2018	106	1	7
1/8/2018	107	1	8
1/9/2018	108	1	9
1/10/2018	109	1	10
1/11/2018	110	1	11
1/12/2018	111	1	12
1/1/2019	112	1	13
1/2/2019	113	1	14
1/3/2019	114	1	15
1/4/2019	115	1	16
1/5/2019	116	1	17
1/6/2019	117	1	18
1/7/2019	118	1	19
1/8/2019	119	1	20

Result:

GPI,ROI,TT are all calculated measure.

ROI = Sum('Table1'[revenue])

TT = COUNT('Table1'[qty])

GPI = DIVIDE([ROI],[TT])

KPI	2018	2019	DIFFERENCE
GPI	105.5	115.5	10
ROI	1266	924	342
TT	12	8	4

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but one of ways is to create Calculation Groups.

Please check the below picture and the attached pbix file.