topic Re: RLS- with 2 user Columns data filter dyamically in DAX Commands and Tips

RLS- with 2 user Columns data filter dyamically

Anonymous — Tue, 04 Mar 2025 06:30:31 GMT

Hi
when Email 1- apple login he should see the data, same way Email 2 column's mentioned users also should see the same Apple data. How implement RLS for these scenario.
> what ever the Email 1 user see the data, same way all the users in the Email 2 also should see the same data as Email 1
> Email 1 and Email 2 are from same table

Thanks

Re: RLS- with 2 user Columns data filter dyamically

ValtteriN — Tue, 04 Mar 2025 06:56:55 GMT

Hi, Try something like this in the dax editor of rls:

[Email1] == USERNAME() || SEARCH(username(), [Email2], 1, 0) > 0

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: RLS- with 2 user Columns data filter dyamically

Anonymous — Tue, 04 Mar 2025 07:56:21 GMT

VA Syntax error when i use the DAX Shared by you . Any help please

Re: RLS- with 2 user Columns data filter dyamically

v-prasare — Fri, 09 May 2025 03:37:14 GMT

Hi Anonymous,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: RLS- with 2 user Columns data filter dyamically

v-prasare — Wed, 14 May 2025 04:42:53 GMT

Hi Anonymous,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: RLS- with 2 user Columns data filter dyamically

v-prasare — Tue, 20 May 2025 13:41:26 GMT

Hi @VGL321,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query