Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

RLS- with 2 user Columns data filter dyamically

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

 

DAX

5 Replies

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    1 year ago

    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/

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

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

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    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

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    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

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    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