Roles - Row Level Security and Aggregated Data

[Rate]

Hello!

I am starting to work with roles and Row Level Security, and couldn't find any documentation on the following. Imagine I have 3 groups of employee (A, B and C), and I want to compare how A is doing against the average of A+B+C.

Could I do something so that employee A can only view his information (thus not B or C) but, at the same view, also view the average of A+B+C?

When I tried including a role by type of employee, as expected, Employee A could only see the average of A.

Any ideas?

[v-frfei-msft · Accepted solution]

Hi @Rate ,

I think that should not be achieved. As if the RLS is applied, then you cannot get the average of all groups. We can only create three new fact tables of Aggregated Data in data source to work around.

Regards,

Frank

[Rate]

Great, thanks for the response! Will work with the summary tables you mentioned.

Thanks!