Forum Discussion

v-merpet's avatar
v-merpet
Microsoft Employee
6 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

v-merpet's avatar
v-merpet
Microsoft Employee
6 years ago

This is testing data and it lives on a single table for a feasability study. One Table - Two columns : Team Name and Client Name. The Progression Breakout Table is Team to Count of Tenant Name. Tables A B and C are Tenant Name filtered by associated Team. So a client can start in Team B and progress to Team C. Or they can be in Team A and move through B to C. (No current additional tables and no relationships engaged. Always forward progression as later dates we will be adding more team sequences.) 

** I corrected the name on this visual to eliminate any confusion.