Forum Discussion
Helper IFilter Table based on slicer value and multiple conditions
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
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
3 Replies
- amitchandak
Super User
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]) )
maramaThank you, but join turned out to be too slow in my case (I have more then 100K records)
- v-easonf-msft
Community Support
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
