Trying to link two tables together from D365 BC to create a report for posted invoices with sales $

[sregimand]

Trying to link two tables together from D365 BC to create a report for posted invoices with sales $ amount. Here are the two tables:

1. PostedSalesCreditMemos

2. PostedSalesInvoice_Line

In 'postedSalesCreditMemos' [Amount_Including_VAT]  table there are few credits that need to be subtracted from postedSalesInvoice_Line[Amount_Including_VAT] table.

I am able to subtract the two columns from two tables with this measuring formula:

TotalSales Measure = sum(PostedSalesInvoice_Line[Amount_Including_VAT])-SUM(PostedSalesCreditMemos[Amount_Including_VAT])

However, I like to create a column or to run a measured statement to show each row, instead of the sum results. 

My table model is Many to Many (*.*)  ---> Cross Filter direction = Both

I have tried many different options to make my model to many-to-one or one-to-many with no success. 

Any help is appreciated.

[amitchandak]

@sregimand , Column in M-M would be a challenge. 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[sregimand]

---

@amitchandak wrote:

@sregimand , Column in M-M would be a challenge. 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

---

---

@amitchandak wrote:

@sregimand , Column in M-M would be a challenge. 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

---

[sregimand]

Total Sales is correct, however when I try to subtract credit applied to an invoice the Total Measures becomes as negative. 

[sregimand]

I have tried many ways of assoicating the two tables as many-to-one or one-to-many with no success.