Forum Discussion

dzakyramadani's avatar
dzakyramadani
Regular Visitor
6 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

mh2587's avatar
mh2587
Super User
6 months ago

Kindly review both the upper and lower records. I encountered a similar issue previously, which was caused by the same record appearing in both places.

dzakyramadani's avatar
dzakyramadani
Regular Visitor
6 months ago

sorry, what do you mean by upper and lower record? i ensure all the composite key have no duplicate anywhere, all composite key on fact table exist in the table1, and even ensure all the building block of the compositekey type, and value is the same. 

  • v-achippa's avatar
    v-achippa
    Community Support
    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

    • v-achippa's avatar
      v-achippa
      Community Support
      6 months ago

      Hi dzakyramadani,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        6 months ago

        Hi @dzakyramadani,

         

        We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

         

        Thanks and regards,

        Anjan Kumar Chippa