How can I add/subtract/divide two columns in a matrix table?

[Cuda1337]

I'm VERY new to PowerBI, so I apologize if I don't use the right terminology. 

I have a matrix table in my report. 

I am using a date slicer and an employee name slicer to show me two columns of values, that are pulled from two separate tables.  These tables have a mutual relationship with a date table and with a (I think it's called a fact table?) that has employee names. 

That all works perfect. 

The problem I have is that my two columns display employee cost, and employee revenue generated.  I want to add them together to get a profit/loss per employee. 

I cannot figure out how to add two columns on a filtered table to display a third column with the calculation applied. 

Any help is much appreciated!

[Idrissshatila · Accepted solution]

Hello,

you can create a new measure that would be

Profit / loss= sum(employee revenue) - sum(employee cost)

and then add it to your matrix

check this link to see how to make a measure https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin

[Cuda1337]

I've tried that, and it looks like this: 

Profit/Loss = SUM('Appointment Billing Info_202212'[Contract Amount] - SUM('Combined Payrolls'[Total employer cost]))

I'm getting an error, however, that says 'the sum function only accepts a column reference as an argument'.

[Cuda1337]

Nevermind!  I had the parenthesis wrong.  I've fixed it, and it works now.  Thank you so much!

[Idrissshatila]

Great!

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin