Calculate the difference between two columns in a matrix when each row is a measure.

[Trudgeon]

Hello,

I'm working on a matrix in Power BI that compares transaction types ACTUAL vs FORECAST.  Each row is it's own calculated measure.  Is there any possible way to create a difference column? 

Any help would be greatly appreciated.

[Trudgeon]

Due to the fact that the measures used different figures in their calculations (volumes, revenue, etc.), I determined that it was not possible to achieve what I needed to via a matrix.  I had to resort using cards with visual level filters for each field.  It worked, but it took a long time to construct.

[v-yulgu-msft]

Hi @Trudgeon,

Here are some similar threads for your reference:

Difference between two columns in matrix visualisation

Difference between two columns or rows

Besides, for more advice, please post some dummy data of source dataset table.

Best regards,

Yuliana Gu

[Ashish_Mathur]

Hi,

I am not sure if that is possible.  I depends upon the data layout.  If you could share your PBI file, i can take a look.