Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Row level security using if-clause

Hello,   I am trying to implement a RLS to limit the security. We are receiving the values to restrict on from a database directly, so in theory I only need to apply a simple RLS where I restrict o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello, 
I encountered the same scenario. Did you resolve your issue? 

How to create a role with DAX. for example if you wanted to have `Restricted access: Company`? 
In my case  I would like to get the `company` of current user (by matching the id)  and filter rows by this company. 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

yes, I have solved my issue, but I solved it differently, not with a DAX statement in the role setup.

I have created calculated tables, that crossjoin the users that have a * (access to everything) with the respective dimension. The DAX statement you'll need is CROSSJOIN().

 

For example: User A has access to all companies. I therefore receive one line from my security table like the following:

User: Mark

Dimension: Companies

Restriction: *

 

I am then crossjoining this line with the company dimension, so I am getting a new table that delivers me the user Mark and all companies that exist in that dimension.

This table you can then use to place the RLS restriction on.

 

Hope this helps, good luck!

 

  • ncbshiva's avatar
    ncbshiva
    Advocate V
    6 years ago

    Hi,

     

    Can you please share me the DAX code ?

     

    Regards

    Shiva