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 departme...
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!

     

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!

     

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Dgreen23 although changing the relationship direction to both will solve the problem but I will not use it as it can have a performance impact. Read more here.

       

      The recommendation is to use CROSSFILTER function in the measure and use both  in it where required

       

      Cheers,

      P

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Dgreen23 so you have a department table that also has a relationship with utilization by company table.

    • Dgreen23's avatar
      Dgreen23
      Helper III
      6 years ago

      parry2k 

      No sir. Both of the utilization by company tables hold identical data. However, the key difference between them is one is calculated strictly by the department and the other one is on an employee basis. Unfortunately, I have not been able to get the data to come together correctly. Hence why I need to combine those two further. 

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Dgreen23 as much as I want to get this resolved but I still not fully sure. Why not put sample data in an excel (redact it) and send it over, it will help to understand the problem and hence the solution.