RLS- with 2 user Columns data filter dyamically

[VGL321]

Hi 
when Email 1- apple login he should see the data, same way Email 2 column's mentioned users also should see the same Apple data. How implement RLS for these scenario.
> what ever the Email 1 user see the data, same way all the users in the Email 2 also should see the same data as Email 1
> Email 1 and Email 2 are from same table 

Thanks

[ValtteriN]

Hi, Try something like this in the dax editor of rls:

[Email1] == USERNAME()  || SEARCH(username(), [Email2], 1, 0) > 0

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[VGL321]

@VA Syntax error when i use the DAX Shared by you . Any help please