Use DAX to ignore RLS for specific aggregate measures?

[OneWithQuestion]

I have RLS on our sales data in our report.

However, I wanted to show aggregated sales numbers at the regional level that everyone can see regardless of the RLS.

Is there a way to write DAX that can bypass or ignore the for specific measures?

Thanks!

[amitchandak · Accepted solution]

Refer, if this can help

https://community.powerbi.com/t5/Desktop/DAX-Code-for-Dynamic-RLS/m-p/807960

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[kentyler]

Yes, you can use a combination of CALCULATE() and ALL() to have a specific measure ignore the filters being placed by other measures.