row level security & overall sum

[eddydm]

Hi,

I'm experimenting with Row Level Security.
In this power-bi-project we have different departments with their own budget.
I want to experiment with some roles (by department) and indeed i can see only the budgets of the departments i'v access to. All right!

But I want to see also the total budget of the whole company, but I only can see the total budget of the departments i'v access to. I can understand the result, but in this case i realy want the total budget of all the departments, even those i don't have access to.

I don't need to see all the details of the other departments, not even the budget of the other departments, but I need access to the sum of all the budgets!

How can I do this?

Thanks in advance.

[ankitpatira · Accepted solution]

@eddydm I think easiest and the only solution is to bring in only sum of budget amount as a second data source in the report. There won't be any RLS applied to that second data source and so it will work in both desktop and service regardless of the RLS defined on your original dataset.

[eddydm]

@ankitpatira : thanks for your respons. I was also thinking about that solution.

I hoped there was another wa, because in reality I don't want to display only the budgets but also some calculated values.

As I understand you well, I'v to copy all the tables I need, define all the calculated columnes again and define all the measures again (but with references to the new tables).

A lot of work I hope I don't have to do!

[v-qiuyu-msft]

Hi @eddydm,

As we know, the RLS rule is applied on the table level with the report. You can image if one part of table data are affected by RLS rule but others will not, it's hard to decide which part of the table should be affected. So both detail information and total value are affected by RLS rule make sense.

In your scenario, the only way to work around this issue is suggested by @ankitpatira, to create another table which doesn't apply RLS rule, and use this table to calculate total values.

Best Regards,
Qiuyun Yu