Advance DAX on RLS

[alexanderandro]

Hello,

I just started learning Power BI and I bumped into this problem regarding Row Level Security using advance DAX. I have this Table filter DAX expression [Email] = UserprincipalName but it turned out that all of the data in the column I am referring to had a fix suffix (e.g. @mydomain.com) but some of the user audience I want to share the report to authenticates with only @domain.com suffix. I tried creating another column [AlternateEmail] and used SUBSTITUTE function to replace @mydomain.com to @domain.com and set the Table filter DAX expression to [Email] = UserprincipalName() || [AlternateEmail] = UserPrincipalName() but did not work. Can you do advance DAX on the Table filter DAX expression using userprincipalname() function that accepts both?

Thank you in advance

[alexanderandro]

Hi Icey,

Thank you for your response. I appreciate the video and I have done this. It turned out that the audience I want to share it to has multiple domains as there were a lot of branches globally not only @domain.com and @mydomain.com. I am guessing we acquired a bad mapping data, so my approach is a sort of like dynamic filtering on the columns we are using. Is it possible to apply this on the table filter DAX expression? 

[Icey]

Hi @alexanderandro ,

Sorry, I'm confused. Isn’t the result returned by your formula always "TRUE"?

---

---

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Icey]

Hi @alexanderandro ,

I have this Table filter DAX expression [Email] = UserprincipalName but it turned out that all of the data in the column

---

How did you test it? Did you both select "Others" and your new role like below?

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.