Forum Discussion

Dgreen23's avatar
Dgreen23
Helper III
6 years ago
Solved

Multiple Active Relationships

I have a master company table that I link everything to. Now I have run into an issue where I need a table to look at that master company table but also look at another table and link to its department section. If I link on the Company then it gives all results for the company but will not filter down when a department is selected. If I link on the department it filters down by department but shows all companies and the people associated to that department. Help.

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi  Dgreen23 ,

     

    Maybe it's a direction issue,see below:

    Pic 1:Filter specification will flow from CompanyProject to Project Hours (as shown in the following image), but it won’t flow up to CompanyEmployee.

    Pic 2:However, if you set the cross filtering direction to Both, it will work. The Both setting allows the filter specification to flow up to CompanyEmployee.

    '

    So try to modify the directions between tables,maybe you will get the right result.

     

    Here is the reference.

     

    https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

7 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Dgreen23 can you share sample data and relationship diagram and required result. It should work but need more details.

    • Dgreen23's avatar
      Dgreen23
      Helper III
      6 years ago

      parry2k ,

       

      I've attached a diagram. I cannot share the data, unfortunately. The required result is that if company x is selected and then their lathe department is selected then I should only see the company x lathe department. Sorry for the lack of data. Let me know if there is anything else I can provide

        

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        Hi  Dgreen23 ,

         

        Maybe it's a direction issue,see below:

        Pic 1:Filter specification will flow from CompanyProject to Project Hours (as shown in the following image), but it won’t flow up to CompanyEmployee.

        Pic 2:However, if you set the cross filtering direction to Both, it will work. The Both setting allows the filter specification to flow up to CompanyEmployee.

        '

        So try to modify the directions between tables,maybe you will get the right result.

         

        Here is the reference.

         

        https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!