Adding totals to RLS

[Anonymous]

Hi,

I have a dataset which contains all sorts of metrics for different departments in my company. For all these metrics I've made multiple visualisations in a dashboard. I've added Row Level Security so that each department can only see the values and visuals of their own department. However I also need the option for each department to see the values of the entire company (so department1 + department2 + department3, etc.), without them being able to see the data of other individual departments. I would like to implement this by adding a filter in the header of the dashboard, where the user can select his own department (e.g. 'department1') or the total sum of all departments ('total'). This way all the visuals will change based on the selection in the filter.

How can I make this?

[samdthompson]

Hello, I have done this same thing. The fix for me was to create a separate fact table of all the company wide stuff summarized to a departmental level. RLS is not applied to the company wide table only to the detailed table. The result is that i can surface summarized data alongside security protected data. 

I am not sure how your model works, but for me it was a reference step in power query folllowed by a grouping step then i created all the same relationships bar the departmental one.