Forum Discussion
DAX command to consider multiple =USERPRINCIPALNAME values in same column
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 mult...
Assuming that your data is similar to below.
| Store | |
| Store1 | [email protected];[email protected] |
| Store2 | [email protected] |
| Store3 | [email protected] |
| Store4 | [email protected];[email protected] |
Then you could try below DAX in the RLS window.
VAR __email = USERPRINCIPALNAME()
VAR __condition =
IF ( CONTAINSSTRING ( 'Table'[Email], __email ), TRUE (), FALSE () )
RETURN
__condition