Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
"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.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |