Data Model and Table Help!

[Sdhn420]

This is what the output should be:

I need to display all the sales orders which have been invoiced along with their order qty, sales qty, sales invoice value and product.

Sales Order	Product Description	PO Number	Sold-to pt	Order qty	Material	Customer Name	Item	Invoice Qty	Net Value
222	XYZ	P77	111	6	457	YYY	10	64	66.24
222	ABC	P77	123	6	456	YYY	20	64	70.98

But I am getting aroud 20 rows for just for the first record. 

This is my data model - 

I have tried to merge and group the tables as well but always get duplicate records in the table. Even tried to create unique keys by combining colums (Sales document no. and material code). 

Any help in this matter would be highly appreciated. I am stuck with this for 1 week now.

[PaulDBrown]

@Sdhn420 

OK, so I've given this a shot, though I cannot really be sure if the outcome is what you expect.

The first thing to point out is that the problems are probably caused by the many-to-many relationships you have between your :
- Delv Track and Sales Order table

- Customer Master and Sales order table.

With the data you sent me, I have set the model up like this:

And this is the table based on your example:

I've included the PBIX file

[PaulDBrown]

@Sdhn420 

any chance you can share a sample PBIX file (or dataset) to play with?

[Sdhn420]

@PaulDBrown  You can download the sample excel files from here - https://drive.google.com/drive/folders/1Xh1ospXqhYzp3jp3gcz-L_XFMbqi-iqd?usp=sharing