DAX for calculating Job Profit

[Bluespark]

Hi experts,

I am fairly new to this and already spend some time to find out myself but I am not making much progress so really would appreciate your help:

I have a table with purchases and sales that looks like:

Order.Sales Person	Amount	SalesInvNo	Total Revenue	PO Expenses	Profit	TrType
	-505	tt555		-505	505	Purchase
Peter	2689.2	tt556	$2,689.20		2689.2	Sales

What I am looking for is now a DAX measure or another approach to be able to show 

Sales, SalesInvNo, Salesperson, Revenue and expenses in one line. i.e. getting a table where I can see the job profit per invoice?

Thank you very much for your help!

Phil

[Bluespark · Accepted solution]

In the end we came up with a solution: the key problem was that we only had the sales person information set for the sales transactions. So, it was giving us two lines in the visual as one had the sales person name the other one was empty. We added the sales person name via the SQL backend to the purchase transactions and with that got everything in one row as required. If someone has an idea how this could be done with DAX I still would be keen to know!