Team rank after applying RLS

[Ammulu_M]

I have team rank measure before applying the rls it was working fine after applying the rls, i'm getting rank 1.

I have a main file which has employee details like name,id,email,supervisor by date. i have multiple files which results the agent performnces for different KPI's . created relation from main file to all the files. and now applying rls on the main file emp id.

I have team rank calculated for each KPI. now it was changing after the rls.

Before RLS my team ranks and lob ranks for one agent

After RLS team rank and lob rank for same agent

please help me with that. 

[raji_n]

@Ammulu_M I think you have to use another fact table for your ranking, that way RLS wont affect the ranks.

[Ammulu_M]

Could you explain in detail how to do it

[raji_n]

you can apply RLS roles on one table and for the other table, do not apply RLS but simply show the KPI at levels, that way rank will not be affected even when RLS is applied for other parts of the report.

[Ammulu_M]

I have to create connection between those tables right. If i give connection rls will apply to that table also

[raji_n]

no, you need not create a connection with RLS table, you should go over those tables for your rank to work.

[Ammulu_M]

ranks are not working even if i create another fact table

[raji_n]

@Ammulu_M can you share a sample file

[Ammulu_M]

here is the agent Dashboard_testing.pbix

[raji_n]

can you attach it as a file, not able to downloa it

[Ammulu_M]

https://app.powerbi.com/groups/me/reports/f736da61-a746-4f5f-918e-a48ef3c931f8?ctid=9b47157b-2ccc-42... 

i hope this works. If it asks for permission i will approve

[raji_n]

can you upload your file in a google drive and share the link, im not able to access still

[Ammulu_M]

@raji_n Hi, I can't share the file through gmail due to company laptop restrictions. Hope you can understand and please help me out with this.