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.

danielpaduck's avatar
danielpaduck
Helper III
2 years ago

I could try that but is there a way to be able to filter without an explicit relationship in the data model?  Thanks! 

  • danextian's avatar
    danextian
    Super User
    2 years ago

    You can use TREATAS or IN  in a measure to filter another table. Example:

    CALCULATE (
    SUM ( budget[amount] ),
    FILTER (
        VALUES ( budget[region] ),
        budget[region] IN VALUES ( labordetails[region] )
    )
)

    But why avoid a relationship? If you need another aggregattion from the budget table, you will have to create another similar measure.