Implementing RLS with Column having multiple delimited Emails

[shelatMalavR]

Hello There,

I have an interesting scenario where in the i want to implement the RLS using a column which is having multiple Email delimited using pipe '|' symbol. Below is what it looks like

Geo_ID		EmailAccess
12343		emp1@office.com | emp2@office.com | emp3@office.com
23232		emp1@office.com | emp4@office.com | emp10@office.com
34343		emp5@office.com
32323		emp3@office.com | emp9@office.com

so basically i need to implement RLS by using EmailAccess Colum and all the emails  delimited by '|' symbol should have access to relevant Geo_ID and this is sample data so we have to make it dynamic as data will keep on changing.

Is there any way in power BI to achieve this ? 

p.s : i do not wish to split columns using delimitors and implement RLS, niether i want to use unpivot function to do the same as i do not want to change data structure. I am willing to do it using dax functions in Manage Roles itself.

Looking forward for some help and ideas,

Thanks and regards,

Malav Shelat

[shelatMalavR]

Thank you Amit, it worked as expected. 

[amitchandak · Accepted solution]

@shelatMalavR , Create a role using the below statement, Hope the table is joined with region dimension or with fact on region

search(userprincipalname(), [EmailAccess],,0) >0