Forum Discussion
Solved
Multiple Filters across different workbooks
Hello, I am trying to apply 2 filters across 2 different fields in 2 different workbooks. I cannot merge the files as they deal with seprerate data and that would not work. I need to filter by O...
lem5072 , You can create common office and year (if needed date table) dimension and join with both tables and use those dimensions as slicer and visual along with measure from two tables
new tables
Office=
distinct(union(distinct('Table'1[Office]),distinct('Table'2[Office])))
year =
distinct(union(distinct('Table'1[year ]),distinct('Table'2[year ])))
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
Thank you for the help!