PowerBI RLS

[Anonymous]

Hi All,

I am new to PowerBI

I have an table with data like email@gmail.com,email2@gmail.com,email3@gmail.com in EmailAddress column.

I have created a Role in  RLS using Username() function like [EmailAddress]=Username().

But while testing the Role in PowerBI Desktop by passing one emailaddress I am not getting the result as expected.

If I pass all the 3 EmailAddress then it is working fine.

Please kindly help me on this is there any function so I can handle this comma seperated data instead of split.