Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
joshchapman_ps
Regular Visitor

Conditional Row Level Security

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

1 REPLY 1
lbendlin
Super User
Super User

"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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.