Forum Discussion
Help : Calculate the difference between two rows in the matrix table
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!
1 Reply
v-caliao-msftMicrosoft Employee
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