Sum values of multiple lines based on type

[PBrainNWH]

I have a value entry table with two types of entries. Sales Invoices and Adjustments. I want to be able to calculate the total of the sales invoice and adjustments for each Doc No. and Item No. and have the result appear as the Cost (Actual) for the Sales. No sure how to get started. Thanks for taking a look.

For example:

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523