Forum Discussion
OneWithQuestion
Post Prodigy
Post ProdigyUse DAX to ignore RLS for specific aggregate measures?
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 t...
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
Solution Sage
Solution SageYes, you can use a combination of CALCULATE() and ALL() to have a specific measure ignore the filters being placed by other measures.