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...
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

 

 

  • Praj's avatar
    Praj
    Helper I
    3 years ago

    Nevermind Greg_Deckler, The solution worked! I made a small mistake in slicer.

    Cheers,

    Praj