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
Icon for Microsoft Employee rankMicrosoft 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?