Forum Discussion

abc_777's avatar
abc_777
Solution 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?

abc_777's avatar
abc_777
Solution 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
Community Champion
4 years ago

Can't you create a bridge table?

  • abc_777's avatar
    abc_777
    Solution 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

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      4 years ago

      You can create the bridge table using the equivalent to:

      Customer Table =
DISTINCT (
    UNION (
        VALUES ( 'Customer Table'[Customer ID] ),
        VALUES ( 'Summary table'[Customer ID] )
    )
)
      • abc_777's avatar
        abc_777
        Solution Specialist
        4 years ago

        Hi paul

        thanks for your reply.

         

        I have many-to-many relation to ssummary and sales table that has 

        customer_id  in the customer table and Customer_code in ssummary table

         

        how i make bridge table in this case 

         

        moreover, i am querying from customer tale to sales but ssummary table is in middle of customer and sales table