Forum Discussion

joakimfenno's avatar
joakimfenno
Helper V
3 years ago

Overriding row level security

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

 

CompanySalesTotal Sales
A100190
B50190
C40190

 

This is what a user belonging to Company A should see

 

CompanySalesTotal Sales
A100190
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      joakimfenno
      Helper V
      3 years ago

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