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?

PaulDBrown's avatar
PaulDBrown
Community 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
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] )
    )
)