Row level security (ALL function)

[Anonymous]

I want to compare the average FTE from the whole company vs FTE for a specific team, but i ran into a problem when using row level security .

A member of a specific team can only access data for his specific team so i used row level security to implement this.

But this also overrules my ALL function to show the average of the whole company.

Example below:
Correct                                                               After row level security

Company wide	Team A			Company wide	Team A
4%	3%			3%	3%

Is there a solution for this problem?

[Greg_Deckler · Accepted solution]

The only solution to the problem is to create static measures or a separate table where you hold certain, company-wide metrics/aggregations/calculations. This separate table should not be tied to RLS and then you can use the aggregated metrics in that table in your calculations. This way, they cannot see everything except the particular corporate-wide metrics that you make available.