Opposite of Intersect()

[BGD]

Hello Everyone,

Below expression I am using in my Filter table column to select the Location from the table for filter purpose "sort(select(Ticket[Location],USEREMAIL()=[Entered By]))"

But i need to select those location too if the ticket was shared by others. This value is stored in column [Shared with others], this fields is a list of other user id to whom ticket was shared. So I want to use the union of all the location field if USEREMAIL() is equal to [Entered By] and USEREMAIL is in the list [Shared with Others]. Please help me with the expression to achieve the end result.

Thank You 

Bhawna Gupta

[Suvrutt_Gurjar · Accepted solution]

You may want to try

UNIQUE( LIST([Entered By] )+  [Shared with Others])

Combine lists - AppSheet Help

Then expression could be

sort(select(Ticket[Location], IN(USEREMAIL(), UNIQUE( LIST([Entered By] )+  [Shared with Others]))))