Measure that bypasses RLS security

[Syndicate_Admin]

Hello

I have a report with several measures for several countries. I have RLS security configured in the report published by country; and I want to have a measure with the company average; and that everyone can see it regardless of the RLS security you have configured. I can do it?

[v-luwang-msft]

Hi @Syndicate_Admin ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @Syndicate_Admin ，

As per the online document Row-level security, the RLS filter the dataset directly.And   I think you can use a custom column to get the average；If you use a custom column, all users can see the average value.

Similar question refer:

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

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

Best Regards

Lucien