Filter Table based on slicer value and multiple conditions

[marama]

Hi.

I have a table with flights, source and destination cities.

In  slicer, I have a list of cities.

I need a visual table to list all entries where selected city is either a source or a destination.

If my understanding is right, I cannot do a relationship model but I need to filter the visual based on some DAX logic, right? What would the syntax be? Or is there some easier solution?

Thank you

[amitchandak]

@marama , Youcan join city with both source and destination, one join will inactive that you can activate using userelationship 

then measure like below, assume source  join is active

count(Table[source ]) + calculate(count(Table[destination]), userelationship  (city[city],Table[destination]) )

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[marama]

Thank you, but join turned out to be too slow in my case (I have more then 100K records)

[v-easonf-msft · Accepted solution]

Hi, @marama 

You can create a measure  to filter table visual:

Try measure as below:

filter =
VAR a =
    IF (
        SELECTEDVALUE ( 'Table'[destination] )
            IN VALUES ( City[city] )
                || SELECTEDVALUE ( 'Table'[source] ) IN VALUES ( City[city] ),
        1,
        0
    )
RETURN
    IF ( ISFILTERED ( City[city] ), a, a )

Then apply it to visual filter pane.

Please let me know if I misunderstood.

Best Regards,
Community Support Team _ Eason