Overriding row level security

[joakimfenno]

I have an SSAS tabular model where I have implemented row level security

the user (win account) do only access to sales for the company he or she belongs to

this works fine but we also have the requirement that all users should see the total sales (for all companies)

I have tried to acheive this using DAX (excluding company-filter for a measure) but it seems like row level security overrides the measure

another option is to create a separate table for the total but it will result in a lot of duplicate data and possibly a worse user experience when accessing the tabular model directly (requires a better technical understanding)

This is what someone with full access (no row level security) should see

Company	Sales	Total Sales
A	100	190
B	50	190
C	40	190

This is what a user belonging to Company A should see

Company	Sales	Total Sales
A	100	190

[Anonymous]

Hi @joakimfenno ,

So far, to my knowledge, your requirement could be realized currently, because your RLS  set for the table's row, and your sales infomation is one table, the rule from RLS will apply to people. 

The only solution I can think of is that you create a new table with only the sales column in it. now, you could create a measure with this column and add it to the table visual.

I create a example in Power BI Desktop, please refer the attached .pbix.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[joakimfenno]

creating a separate table is an option but it will require storage of a lot of duplicate data which I want to avoid