cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chulendra
Frequent Visitor

Stop Filtering a Visual from Row Level Security

I have page with visuals filtered by RLS (Row Level Security). But there is a one visual that I don't want to filter by RLS. Is it possible to do so? 

 

Thanks in advance

1 ACCEPTED SOLUTION
negi007
Super User II
Super User II

@Chulendra in this case, you will need to create a seperate measure that will do calculations basis non-RLS filter data. 

 

Sometimes, calculations need values that aren't constrained by RLS filters. For example, a report may need to display a ratio of revenue earned for the report user's sales region over all revenue earned.

 

While it's not possible for a DAX expression to override RLS—in fact, it can't even determine that RLS is enforced—you can use a summary model table. The summary model table is queried to retrieve revenue for "all regions" and it's not constrained by any RLS filters.

 

please refer to below links on how to overried RLS in certain conditions.

 

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#:~:text=While%20it's%20not%20possibl....

 

https://community.powerbi.com/t5/Desktop/RLS-creating-a-measure-to-overide-RLS/td-p/37019

 

 

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

1 REPLY 1
negi007
Super User II
Super User II

@Chulendra in this case, you will need to create a seperate measure that will do calculations basis non-RLS filter data. 

 

Sometimes, calculations need values that aren't constrained by RLS filters. For example, a report may need to display a ratio of revenue earned for the report user's sales region over all revenue earned.

 

While it's not possible for a DAX expression to override RLS—in fact, it can't even determine that RLS is enforced—you can use a summary model table. The summary model table is queried to retrieve revenue for "all regions" and it's not constrained by any RLS filters.

 

please refer to below links on how to overried RLS in certain conditions.

 

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#:~:text=While%20it's%20not%20possibl....

 

https://community.powerbi.com/t5/Desktop/RLS-creating-a-measure-to-overide-RLS/td-p/37019

 

 

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors