Incorrect row total when row level security is applied

[RashmitaR]

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.

[v-qiuyu-msft]

Hi @RashmitaR,

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:

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.

Best Regards,
Qiuyun Yu

[ldorn76]

did you ever find a solution to this?

[Baskar]

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