Forum Discussion

Praj's avatar
Praj
Helper I
3 years ago
Solved

How to get rows which is NOT selected in a visual

Hello Everyone,

I am loooking for a way to gather rows which is not selected in a visual. 

For example, 

 

Below is my dataset which has two columns-User and Event Attended.

 

 

I am using a date slicer on column "Event Attended".

 

I know whenever I select Q1 in my slicer, the users who are associated with an event during that quarter is displayed in the table like below image however, I am looking for a way to display the users who are not part of Q1. Is there any way to get these user details(cc,ee,ff).

 

 

Any approach for this problem is appreciated. 

 

Thanks in advance

Cheers,

Praj

 



3 Replies

  • Praj's avatar
    Praj
    Helper I
    3 years ago

    Hi Greg_Deckler ,

    Thanks for your approach. The standard selector is woring in my case however, the inverse selector seems to be blank and doesn't show any data. I am using DATE as a slicer.  Below is the code I have modified for my case 

    Standard Selector = 
VAR __dept = MAX([User])
VAR __products = VALUES('Date'[Event Attended])
VAR __table = SELECTCOLUMNS(FILTER(ALL('Engagement'),[Event Attended] IN __products),"__dept",[User])
RETURN
IF(__dept IN __table,1,BLANK())
    Inverse Selector = 
VAR __dept = MAX(Engagement[User])
VAR __products = VALUES('Date'[Event Attended])
VAR __table = SELECTCOLUMNS(FILTER(ALL('Engagement'),[Event Attended] IN __products),"__dept",[User])
RETURN
IF(__dept IN __table,BLANK(),1)

     

    Below is the visuals

     

    I am not sure if this is because I am using date as a slicer.

     

    Cheers,
    Praj