Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Relationship

Hi

 

Here is my Relationship.

Need to make a relationship between Deck..

 

PBI goes many to many.. any way to make a relationship?

thanks,

 

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi colorfullife,

     

    You can have factlessfact table in between your many to many relationship tables. 

     

    Factlessfact table should contain the distinct key values of your second table. You can map the tables like 

     

    table 1 - -> factlessfact(distinct key values) --> table 2

     

    Relationship should be bidirectional between Factlessfact table and table 2.

     

    Regards,

    Pradeep

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Pauwnrajpp,

       

      Can you let me know how i can make factlessfact table?

       

      Thanks,

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    For what reason are you trying to relate the DP List table to the Piping Table?  The Deck column of both tables should ideally be related to the Deck column of the Deck Order Table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

       

      The reson is when i use the slicer i want all lines in graph want to move.

      for now the piping table doesn't work..!

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    We can create a bridge table using the formula as below and create relationship between tables to achieve your goal.

     

    bridge table = DISTINCT(UNION(VALUES('DP list'[Deck]),VALUES('Tables-JV'[Deck])))

    Regards,

    Frank

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I made a brige table to link decks between tables. But why the deck slicer didn't work for both tables?

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Good morning,

       

      It doesn't let me make direction for both side at the same time.

      so if i make a both direction relationship with piping table, my graph doesn't work as i want. (The deck slicer doesn't work)

      and if i do the other around, my graph get weird shape..

       

      All i want is want to use slicer for lines in graph from different source..!

       

      any ideas??!