Conditional Row Level Security

joshchapman_ps — Thu, 08 Oct 2020 00:59:48 GMT

Is it possible to apply a condition to row level security so if the user pulls in a certain field security is applied? For example, sales managers can see sales for all regions but if they add the customer to the visual then row level security would be applied, and they would only see sales related to their customers. I am using a separate security table with the standard DAX formula to apply row security.

='Customer'[Customer Number]=LOOKUPVALUE('Sales Manager Security'[Customer Number],'Sales Manager Security'[User],USERNAME(),'Sales Manager Security'[Customer Number],'Customer'[Customer Number])

Any assistance is appreciated.

Thanks,

Josh

Re: Conditional Row Level Security

lbendlin — Fri, 16 Oct 2020 01:18:35 GMT

"if they add the customer to the visual" - how? Via "Personalize Visual" ?

You might be able to use ISFILTERED() but only if they not only add the customer to the visual but it also is somehow restricted.

topic Conditional Row Level Security in Developer

Conditional Row Level Security

Re: Conditional Row Level Security