Forum Discussion
Solved
Filter Question - How To Filter A Visual That Is Not Directly Connected To The Filter/Data
Quick question and this might be easy for someone that has done it. Essentially, I have two data sets: Labor Detail and Budget. The Workbook that I took over has a Budget page with a Region filter...
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.
Yes, there are a ton of calculated columns in this data model. I can try a UseRelationship.