Forum Discussion
Multiple Active Relationships
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,
KellyDid I answer your question? Mark my post as a solution!
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
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
Kelly
