Help with DAX Measure-may to many Table

[ravdha85]

Hi Experts,

Below is my model, I have vehicle,customer and sales connected by Order_ID column from a Order Bridge table

In the below Image Table1 I have columns from Order,Vehicle and Sales Tables ,the Sales Maount column shows the correct total and Line item values , But in Table2 I have Introduced a column from Customer table and after that the Sales Amount column total is mis-leading(When I export the results in to csv and do a manual sum the Total values dont match), Is there any work around through DAX or Data model?

[JoeBarry]

Hi @ravdha85 

Are these all seperate tables coming from the database? Or are they tables created from one table? If the tables are coming from one table, you can easily create what you need by using DAX measures. 

If they are not, if the Order table has a unique OrderID, then change all the relationships to one to many from the Order Table to the others andd see if you get the desired result

Thanks

Joe