Skip to main content
Microsoft Idea

Power BI

New

Exclude RLS using DAX (Visual Grand Total)

Vote (5) Share
Umesh K's profile image

Umesh K on 28 Jul 2023 11:30:01

We have a Report, where RLS is applied and it is working as expected. We need to have a functionality where Matrix show Grand Total which should exclude RLS and display entire teams Sales.



Example : If Manager Have 3 Members team and If any one of team member logs in, team member should be able to see only his data but Grand Total/Manager level total should show all the 3 members Aggregation so logged in user can compare the his/her performance.