DAX command to consider multiple =USERPRINCIPALNAME values in same column

[cdavisUser]

We have a single table that we're using currently to set the RLS / DAX statement against. It is working great.

Email = UserPrincipalName()   , very straightforward.

Use case now is allowing multiple users to see the same data. I've read through many of the existing workarounds for this. Is there a way to use Contains or another command that would leave our current schema in tact? Ideally would like to have multiple user names in the same field separated by comma or other delimiter.

Thanks for any insight.

[nandukrishnavs]

@cdavisUser 

Assuming that your data is similar to below. 

Store	Email
Store1	john@abc.com;tom@abc.com
Store2	mat@abc.com
Store3	neel@abc.com
Store4	richard@abc.com;jack@abc.com

Then you could try below DAX in the RLS window.

VAR __email = USERPRINCIPALNAME()
VAR __condition =
    IF ( CONTAINSSTRING ( 'Table'[Email], __email ), TRUE (), FALSE () )
RETURN
    __condition

[lbendlin]

Your single table is the right approach. But it doesn't mean each of your users has to appear only once in it. 😀

[amitchandak]

@cdavisUser ,

Not very clear on the need. See RLS groups can help

https://www.youtube.com/watch?v=oxYQ2GGefrs