Forum Discussion

ravdha85's avatar
ravdha85
Frequent Visitor
3 years ago

Help with DAX Measure-may to many Table

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?

 

 

 

Need Help

1 Reply

  • JoeBarry's avatar
    JoeBarry
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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