Forum Discussion
Using filter slicer to dynamically apply RLS to achieve a default filter
Hi adambhappy
"The users are supposed to be able to access the information for all customers but when they initially log in to the report I want it to be filtered on their customer."
you mean:
your end users have the permission to see all data,
but when they open the report for first time, they can only see their own data.
meanwhile, on the report, there is a slicer which is selected at "own customer" by default.
to see all data, user can switch "own customer" to "all".
Right?
Best Regards
Maggie
Yes, that is the scenario I'm trying to achieve. I can create a DAX measure that evaluates to 1 for each customer based on a combination of the two conditions: they own the customer or they have selected to show all customers. However I can't use that as a filter in the slicer where they select the customer.
