topic DAX command to consider multiple =USERPRINCIPALNAME values in same column in DAX Commands and Tips

DAX command to consider multiple =USERPRINCIPALNAME values in same column

cdavisUser — Fri, 14 Aug 2020 15:18:36 GMT

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.

Re: DAX command to consider multiple =USERPRINCIPALNAME values in same column

amitchandak — Fri, 14 Aug 2020 16:03:24 GMT

cdavisUser ,

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

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

Re: DAX command to consider multiple =USERPRINCIPALNAME values in same column

lbendlin — Sat, 15 Aug 2020 12:08:52 GMT

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

Re: DAX command to consider multiple =USERPRINCIPALNAME values in same column

nandukrishnavs — Sat, 15 Aug 2020 17:45:36 GMT

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