Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Bypassing Role Level Security

Hello everyone,

I am working on a Power BI dashboard and I need to create a measurement that bypassess the role level security. Any ideas on how to or website links that explain a possible solution to this kind of requirement? 
Super User III
Super User III

@csmith whatever you bypass logic is,  you have to build that logic in your RLS formula basically saying if bypass rules = true then RLS DAX return true otherwise RLS rule is applied.


Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at, your one-stop-shop for Power BI-related projects/training/consultancy.

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

@parry2k Thank your for your reply. Can you please give me more details on this? There is a measurement that I don't want it to get effected by the RLS. The Dax formula for the RLS I have right now is [Customer No] = Username(). The measurement is something like

Avg = CALCULATE(TOTALMTD(AVERAGEX('Measures Mkt Shr',[Mkt Shr YTD]),'Time'[Date]). So how would be the DAX formula to avoid the RLS on this measurement? 

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors