Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi 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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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