Forum Discussion
Matrix totals not correct with RLS
I am having an issue where a matrix is not showing the correct totals when using row level security. Instead of showing the total of the rows that are visible, it is showing the grand total for all ...
Hi crobson29 ,
RLS does not work on desktop, you can test it with Modeling->View as.
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
This is the view in the View as mode. The RLS is working as intended in the sense that it is hiding the rows that we want it to hide, but the column totals in the matrix showing the sum of all the rows, not just the ones that are shown.
