Forum Discussion
Filter Question - How To Filter A Visual That Is Not Directly Connected To The Filter/Data
I understand that Offices will set the region but I am honestly not sure how filtering from Region table will affect LD Data. There's just too many tables in between. There's also too many calculated columns.
Your safest route now is too invoke the inactive but direct relationhip between Region and LG Data by using USERELATIONSHIP function in a measure.
I did see that there was a Region table already. I was able to join the Budget table to Region but when I tried to join the Labor Detail table to region it could not make the relationship active indicating that there was another indirect relationship going to that table. The weird thing is that I could not find that indirect relationship. I have taken over the model from a developer that left and there is like 50 tables in this model. Is there anyway for me to find (easily) why it is throwing that error?
The thing with indirect relationship is that they don't flow directly between two tables. There's usually another one or two in between. In your case, that's probably Region >> Table1 >> LaborDetails. In model view, there is an option to view all relationships under Model tab but it only shows the direct ones.
Still in the same view, I would just create a new layout then type region in the search bar and drag any table that contains region to the layout.