Finally tracked down some weird behavior.
If you run a Analysis -> Summarize Data ->Join to Join a table to a layer the join ignores the filters on the table I set in the map.
So Table 1 has a filter on some records in my map. Join this filtered table to Layer 1 and ALL records are used - ignoring the map filter.
Any way around this?