Forum Discussion

JeromeBonte's avatar
JeromeBonte
Regular Visitor
7 years ago

EXCLUDE VALUE in ROW Level security - manage roles

Hi all,

 

I am pretty new to Power BI. Hope you guys can help.

 

I have added a row level security for the sales representatives (so they can only see their own numbers). 

Is it possible to EXCLUDE certain values (in this case: customers) from their view as well? So instead of giving the values which they can see, I would like to exclude a couple of values/customers from their view. 

 

Is this possible? And if so, how should I do it?

 

Thanks a lot, 
Jerome

Need Help

4 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi,


    You can try to create DAX code like below in Manage roles page.

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • JeromeBonte's avatar
      JeromeBonte
      Regular Visitor
      7 years ago

      Hello Amy, 

       

      Thank you for your response.

      Will this exclude the customers? Or should I mention all the customers and skip the ones that I don't want the sales rep to see? 

       

      Kind regards, 

      Jerome

      • v-xicai's avatar
        v-xicai
        Community Support
        7 years ago

        Hi JeromeBonte ,

         

        Yes, you can exclude the customer names that you don't want the sales rep to see in the list behind < >.

         

        Best Regards,

        Amy

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi  JeromeBonte ,

     

    Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy