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
Solved! Go to Solution.
You may want to try
UNIQUE( LIST([Entered By] )+ [Shared with Others])
Then expression could be
sort(select(Ticket[Location], IN(USEREMAIL(), UNIQUE( LIST([Entered By] )+ [Shared with Others]))))
You may want to try
UNIQUE( LIST([Entered By] )+ [Shared with Others])
Then expression could be
sort(select(Ticket[Location], IN(USEREMAIL(), UNIQUE( LIST([Entered By] )+ [Shared with Others]))))
User | Count |
---|---|
17 | |
11 | |
6 | |
5 | |
5 |