Incorrect row total when row level security is applied

Question

Hi, I have applied row level security in my report and when one of my user is having a look at it he is able to see the unfiltered row total

.

Can someone plese let me know how to correct this.

baskar · Answer

Can u please share your calculation measure. and sample table stucture

v-qiuyu-msft · Answer

Hi RashmitaR,
&nbsp;
Based on my test in my environment, I'm not able to reproduce the issue like yours. I create a matrix visual and place a field value in Value Property, set the role based on UserName(). See:
&nbsp;

&nbsp;

&nbsp;
In your scenario, please check which value did you place in Value property of matrix visual, a field or measure? Please try to use a filed like us to see if the row total is correct after using RLS. Also please test a role as the user's email address as above use Test As Role. For more information, please refer to this article: Row-level security (RLS) with Power BI.
&nbsp;
Best Regards,Qiuyun Yu