Forum Discussion

veenashenolikar's avatar
veenashenolikar
Helper V
3 years ago

Row Level Security with multiple conditions

Hello,   I am facing an issue to setup RLS in my datamodel . The scenario is as follows -   I have a security table which enlists information as - (Please note this is sample data) Professio...
Need Help
visheshjain's avatar
visheshjain
Impactful Individual
3 years ago

Hi veenashenolikar,

 

It might sound simple but I have to ask, have you tried using the USERELATIONSHIP() function in your DAX measure for RLS?

 

The function uses inactive relationships.

 

Hope this helps.

 

Thank you,

Vishesh Jain

veenashenolikar's avatar
veenashenolikar
Helper V
3 years ago

Hi visheshjain ,

 

I tried writing the DAX but was not able to form the complete expression.

If you could please help me with the same.

 

Thanks in advance!

  • visheshjain's avatar
    visheshjain
    Impactful Individual
    3 years ago

    Hi veenashenolikar,

     

    Please refer to this doc USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

     

    Also, I can give it a shot, if you can share your sample file.

    One more thing, you will need to replace ALL in your Gender column with 2 rows, unless you have the value 'All' in your data as well.

     

    Thank you,

    Vishesh Jain

    • veenashenolikar's avatar
      veenashenolikar
      Helper V
      3 years ago

      Hi visheshjain ,

       

      I am handling the ALL using a crossjoin with the dimesion table and a custom column.

       

      I will send over the sample file for your perusal

       

      Thanks,

      Veena