Need Help Subtracting data from the same column in a matrix table

[E_Smoove]

Hi there! 

I have a column named "ACCT" in my table that contains rows of portfolios and indexes. I am using the matrix table visual to compare various data points between the portfolio and index. I want to compare the data points in all of the columns between a portfolio and and index in the ACCT column by just subtracting the portfolio from the index. I filtered all of the visuals in the report by the portfolio and index that I want to show. Is there a scalable way to create a third column that will always subtract the portfolio from the index? So the subtraction will always occur between the 2 filtered ACCTs in every report. I want to create 50 reports with dozens of visiuals so I dont want every field to have a separate measure that's hardcoded for the difference between the portfolio and index. In my visual below, "ADRREP01" is the portfolio and "ACWI" is the index. In my visual, instead of seeing the Total of "9.28" in the thrid column, I want to see the difference of "0.09"..

Also, how can I force the visual to always show "ADRREP01" column before the "ACWI" column? It seems like the visual is just going by alphabetical order from the table..

Thanks!

[E_Smoove]

Hi Greg_Deckler,

Thanks for the suggestion, but I dont think I have a "Totals" issue. What I am looking for it to just add a third column to the visual that is just the difference between column 1 and column 2.. I'm not looking for a sum..

Thanks, Ermin

[Greg_Deckler]

@E_Smoove First problem seems like a measure totals issue. First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

Second issue is that you need a Sort By column for your ACCT column.