Order quantity and sales quantity duplicates rows

[Sdhn420]

When I pull in order qty and sales qty along with net value from sales order and sales data set the table gives me multiple rows.

Data set https://drive.google.com/folderview?id=1Xh1ospXqhYzp3jp3gcz-L_XFMbqi-iqd

Data model.

 

[Greg_Deckler]

@Sdhn420 No access to file.

[Sdhn420]

Try now https://drive.google.com/folderview?id=1Xh1ospXqhYzp3jp3gcz-L_XFMbqi-iqd

@Greg_Deckler 

[v-deddai1-msft]

Hi @Sdhn420 ,

Would you please show us more details about your issue and pbix file with your data model? You screenshot is too small to view.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Greg_Deckler]

@Sdhn420 Oh, I thought I was going to get the PBIX file, do I have to build the data model myself?