Hi.
Thank you so much for looking into my issue.
I acutally managed to solve it in a bit different way than suggested here, but I still have an issue.
I now have a calculated table that refers to remote table. This results in refresh faillure when published. How can I get about that?
I combined the columns in a new table this way:
WH status table = UNION(
SELECTCOLUMNS('Warehouse 3 table', "Groseries", 'Warehouse 3 table'[Groseries], "Country", 'Warehouse 3 table'[Country], "Status", 'Warehouse 3 table'[Status]),
SELECTCOLUMNS('Warehouse 4 table', "Groseries", 'Warehouse 4 table'[Groseries], "Country", 'Warehouse 4 table'[Country], "Status", 'Warehouse 4 table'[Status]),
SELECTCOLUMNS('Warehouse 5 table', "Groseries", 'Warehouse 5 table'[Groseries], "Country", 'Warehouse 5 table'[Country], "Status", 'Warehouse 5 table'[Status]))
From there I just made a simple relationship to Table 2. With Groceries in Table 2 filtering Groceries in the new WH Status table.
