cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

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
Resident Rockstar
Resident Rockstar

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

Community Support
Community Support

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.

did you ever find a solution to this?

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors