cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RashmitaR Member
Member

Incorrect row total when row level security is applied

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

 

.row-tot.png

 

Can someone plese let me know how to correct this.

3 REPLIES 3
Super User
Super User

Re: Incorrect row total when row level security is applied

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

Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Incorrect row total when row level security is applied

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:

 

q1.PNG

q2.PNG

 

q3.PNG

q5.PNG

 

q4.PNG

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ldorn76 Frequent Visitor
Frequent Visitor

Re: Incorrect row total when row level security is applied

did you ever find a solution to this?