Apply AND logic to filter a visualisation using multiple selections in another

[petetai]

Hi,

A very simplified version of my database has three tables:
* Stops stores the locations of bus stops (primary key: StopID)

* Journeys stores the details of various passenger journeys (e.g. start time, origin, destination and primary key JourneyID)

* StopJourneyMap lists which journeys go past which stops. I.e. it has just two columns: StopID and JourneyID

Ultimately what I'd like to do is let the user select some stops in a table visualisation and then in a map visualisation show the origins and destinations of journeys that go past those selected stops.

Crucially though I'd like to show only the journeys that go past ALL of the selected stops. Currently I'm struggling with that first step. I've got two table visualisations - One that shows the Stops table and another that shows the StopJourneyMap table. When the user clicks on a row in the Stops table visualisation, it filters the StopJourneyMap to show which journeys go through that stop, which is fine. However, when the user selects another stop (Ctrl+click), the StopJourneyMap table is filtered to show all journeys that go through either stop. How can I change that behaviour so that the StopJourneyMap table is filtered to show only journeys that go through *both* the selected stops?

[v-chuncz-msft]

@petetai,

Try using INTERSECT Function in your measure.

[petetai]

Still struggling with this. I created a measure that calculates how many stops have been selected and a then tried to apply this as a filter to filter for routeIDs that are associated with that many stops. But I couldn't get this to work. So perhaps measures were a red herring.

I'd be grateful for any pointers.