Matrix totals not correct with RLS

[crobson29]

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 the rows, even the ones that are filtered out.  Is this normal functionality? I would like it to show the total for only what is visible.  Here is an example of the problem:

[Anonymous]

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.

[crobson29]

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.