Forum Discussion
Solved
Filtering across tables with Visuals for Progressive Data.
I am trying to see all of my Members that have come thru my process. When I select Team B here I want to see all of the tenants that are in Team A as well as Team C if they transitioned. If they came...
HI v-merpet,
Current, slicer/filters do not support except filter effect.
I'd like to suggest you write a measure with except function to get the reverse result as a filter and use on the visual level filter of your visuals. (please break the relationship from the slicer to current visual)Measure = VAR selected = VALUES ( Selector[Column] ) VAR revSelected = EXCEPT ( ALL ( Table[Column] ), selected ) VAR currItem = SELECTEDVALUE ( table[column] ) RETURN IF ( currItem IN revSelected, "Y", "N" )Regards,
Xiaoxin Sheng
HI v-merpet,
Current, slicer/filters do not support except filter effect.
I'd like to suggest you write a measure with except function to get the reverse result as a filter and use on the visual level filter of your visuals. (please break the relationship from the slicer to current visual)
Measure =
VAR selected =
VALUES ( Selector[Column] )
VAR revSelected =
EXCEPT ( ALL ( Table[Column] ), selected )
VAR currItem =
SELECTEDVALUE ( table[column] )
RETURN
IF ( currItem IN revSelected, "Y", "N" )
Regards,
Xiaoxin Sheng
Pure Genius, This worked perfectly and was so elegant. Thank you so much for teaching me more about this function.
