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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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