Forum Discussion

danielpaduck's avatar
danielpaduck
Helper III
2 years ago
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...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    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.

danextian's avatar
danextian
Super User
2 years ago

Hi danielpaduck ,

 

Have you tried creating relationships? I would create a dimension table containing the regions and connect this to both Labor Detail and Budget. I would then use the region column from this dimension table in the visuals. The relationship would like below, flowing from the dimension to the fact tables:

And if you need to slice the data by date as well, you'll need to create a separate dimension table for that. You can use the CALENDAR function in DAX. You can create a region calculated table with dax (example: DISTINCT(LaborDetails[RegionColumn]) or you can use the Enter data feature under Home tab. You can create a calculated table under Modeling tab.