Forum Discussion
Use 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 that can bypass or ignore the for specific measures?
Thanks!
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
2 Replies
Yes, you can use a combination of CALCULATE() and ALL() to have a specific measure ignore the filters being placed by other measures.
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
