RLS is showing incorrect numbers

Hi Anonymous 

Thank you for the more detailed information, please try the following steps to see if they help.
1. After creating RLS roles in Power BI Desktop, use the "View as" feature to validate the RLS results.
If RLS works and the device count are displayed correctly, then verify the workspace permissions of the role members as mentioned by raji_n above. RLS roles doesn’t apply to members who are assigned to the Admin, Member, or Contributor role in the workspace. Please refer to:https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#using-rls-with-workspaces-in-power-bi

2. If it fails to validate the RLS effect using the "View as" feature in Power BI Desktop.
It is likely that the relationship between the tables and the settings of the page filters are causing the device counts to display abnormally.
In my simple test, no relationships are set up between the tables and page filtering is performed using the SubOpCo field in each of the three tables. This way the RLS I have set up seems to work correctly.

If your problem still exists, please let me know how you set up the relationship between the tables and the filtering of the pages or tables.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.