Forum Discussion
RLS Filter User But Show Other Users Anonymously
Microsoft EmployeeHi Anonymous,
I'm wondering if you could add a Rank column in your user table first, then create a new summarized table which contains only the rank and other information you want users to compare with in this scenario(mark sure there is no any relationship with this summarize table). :smileyhappy:
Regards
So, basically you are saying to substitute the username's with a number? Including the user viewing their report. I would prefer if the user viewing the report could see their own name, but everyone else as "Anonymous". I am also not trying to show a "rank", just a way for the user viewing to compare where they are with the rest of the group.
Can I get a little more input on this? How am I using this summarized table? How do I make it so that user "Bob" see's his metric and his name as "Bob", but everyone else anonymously? And then apply that to every user
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?
- v-ljerr-msft
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