Forum Discussion
RLS Filter User But Show Other Users Anonymously
Hi, I am able to use the Role Management feature to filter out data per username. This shows only the data for the specified user and hides everything else. However, I still want the user to be able ...
v-ljerr-msftI am hoping to get this result using RLS. I currently have a dynamic RLS setup with username(). Could some DAX function using SUBSTITUTE( create this result?
Hi Anonymous,
After a few tests, I don't think there is a possible solution to get the exact expected result in your scenario.
To get your expected result, you may need to add a column with values of the current user name, and "Others". However, the USERNAME function cannot be used in calculate columns/tables. So it may be not possible to determine who is the current user or "Others" in the new column/table. :smileyhappy:
Regards