Measure not responding to table slicer

[Cool blue]

Hi, I have a table in an excel file which has auto filters on and I have pivot tables derived from it. The table is included in the data model.

I have slicers on the pivot tables, which are on different worksheets but, I want to filter all of the pivots together by selecting the visible cells in the table.

In the pivots, I have a Value measure like this...

Value := CALCULATE(
 SUM(openOrders[Amount]),
 ALLSELECTED(openOrders[WH]) // WH is source warehouse
)

When I use this measure in one of the pivots, it sums across all warehouses selected in its local slicer. It does not respond to the table filters.

I also tried...

= CALCULATE(
 SUM(openOrders[Amount]),
 Values(openOrders[WH])
)

but got the same result

I also tried to add a slicer to the table and filtering with that but, still the same result.
One thing that is strange, when I select Options for the table slicer, the Report Connections icon is disables.

Any suggestions?