Forum Discussion
After RLS applied , user are not able to saw the data in report
Thank you for your steps, But my actually problem is when after applied RLS ranks are not working properly, example in 1 team manager under 10 employee, based on performance ranks are given ex: employee "SACHIN" rank is 4/10, but sachin logged and checking rank is 1/1, this is wrong rank, before applied RLS shows 4/10- correctly, After applied RLS 1/1, how to achieve correct rank
Hi, Anonymous
I'm sorry I didn't understand what you meant. Your problem may be with the measure of your ranking
I create another sample table:
Then create a calculated column, try the following DAX:
RankColumn = RANKX('Table','Table'[Performance],,DESC,Dense)
When you select ManagerID, the rank will not change:
Create a new RLS role and observe with that role:
You can't use measure to rank because with RLS, it already filters out the rest of the data for you. It's equivalent to saying that your underlying data source "went from 10 employees ranked" to "ranked from 3 employees who belonged to manager ID 102". So you need to use calculated columns to fix the ranking.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.