RLS- with 2 user Columns data filter dyamically

[VGL321]

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

[v-prasare]

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

[v-prasare]

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

[v-prasare]

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

[ValtteriN]

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/

[VGL321]

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