Help : Calculate the difference between two rows in the matrix table

[achaitrar91]

PBI is new to me. In tableau I just had to pick 'difference' tab from the dropdown and that use to do the trick .I'm trying to calculate the difference between two rows in the matrix table

Actual data used to create the matrix

TEST_GROUP	AVG_BAL	AVG_1	AVG_2	AVG_3
TEST1	20	30	40	10
CTRL1	10	30	40	0.28
TEST2	30	30	40	0.09
CTRL2	40	30	40	0.09
CTRL3	50	30	40	0.04
TEST3	10	30	40	0.04
CTRL4	20	30	40	0.03
TEST4	10	30	40	0.03
CTRL5	30	30	40	0.03
TEST5	50	30	40	0.03
CTRL6	60	30	40	0.02
TEST6	70	30	40	0.02
CTRL7	80	30	40	0.02
TEST7	10	30	40	0.02
CTRL8	10	30	40	0.02
TEST8	10	30	40	0.02
TEST9	20	30	40	0.11
TEST10	10	30	40	0.04

Matrix- This is how my table looks like

groups   avg-bal   avg-1   avg-2    avg3

test         600         50        60         60

control    200        40         30         20

This is how I want my matrix table to look like

groups           avg-bal   avg-1   avg-2    avg3

test                   600         50        60         60

control             200        40         30         20

Difference        400        10         30         40

Any help is appreciated!

[v-caliao-msft]

@achaitrar91,

Currently, there is no such a option that allow to change the Total row to Difference row. If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Thank you for your understanding.

Regards,
Charlie Liao