Forum Discussion

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
4 years ago
Solved

Table over a table

Hi,   I have a following relationship where the customer table is related to ssummary (one to many) tables then summary table have a relation to the sale table (many to many)   and so when i do t...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Can't you create a bridge table?

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

The wrong result may have to do with the fact that two tables have a many-to-many relationship

  • abc_777's avatar
    abc_777
    Icon for Solution Specialist rankSolution Specialist
    4 years ago

    yes, paul, and the database designer make this incorrect table relationship. there is no Key that I can join with the customer table direct to the sale table.

     

    So I need a measure or DAX formula or solution that I can over calculate customer and sale table

     

    thanks

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Can't you create a bridge table?

      • abc_777's avatar
        abc_777
        Icon for Solution Specialist rankSolution Specialist
        4 years ago

        i have company code in the sale table and ssummary table and 

         

        customer_id  in the customer table and Customer_code in ssummary table

         

        would be able to help me how i create bridge using distinct