Forum Discussion
Undo (dynamic) row level security with a DAX filter?
Once Row Level Security is applied, the table context is filtered, so your calculation will only take the context with accessing users' own data only. And the internal working of Power BI is a Tabular model, there's no "Enable Visual Total" feature like Multidimensional Model. So it's not possible to undo RLS on any specific DAX formula.
For your requirement, I suggest you add a calculated column to get the average on ALL table. Since the calculated column is along with row leve, you can still get correct result when RLS is applied.
Regards,
Many thanks for your response. I can see that it has taken some time to make an example for me, which I and my team highly appreciate. I have just another requirement.
In our benchmark values E.G. average sales amount of all users, which can be created by a calculated column we need to filter, we need to exclude the sales amount of the users viewing the report. That way, the user can benchmark him/herself to other users.
Do you know if a calculated column can be made to exclude the data from the user viewing the data via RLS?
If this is not possible, we might have to think about copying parts of our tables or do no use RLS at all, but just make 100 different reports for our users.
Many thanks in advance!
