Forum Discussion

dzakyramadani's avatar
dzakyramadani
Regular Visitor
7 months ago
Solved

One to Many Relationship Problem

Im trying to create a table that list all value from table 1(combination of LOB, Division, Dept) and add information based on Table2(Fact table). Ive made a compositekey to bridge the combination of ...
Need Help
  • v-achippa's avatar
    v-achippa
    6 months ago

    Hi dzakyramadani,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you cengizhanarslan and mh2587 for the prompt response. 

     

    Based on your description this is expected behavior. Even with a correct one to many relationship, power bi visuals will only show dimension rows that have matching fact rows when any column from the fact table is used in the visual or slicer.
    Relationship direction controls only filter propagation. To keep all dimension rows visible, use only Table1 columns in rows and return fact data only through measures.

     

    Thanks and regards,

    Anjan Kumar Chippa

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 months ago

Hi,

In Table2, using Power Query, we can first assign index numbers based on Number, Alphabet and colour combination and then write a calculated column formula in Table1, to get your desired result.  Would be OK with this approach?