Forum Discussion

raja_94's avatar
raja_94
Frequent Visitor
4 years ago
Solved

RLS with Numerical values based

HI all i want to implement RLS dynamic with numerical values ,  i want 11 series can see one person 12 series can see one person like this  suggest us.   thanks, raja.
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi raja_94 

     

    Create two roles and write below DAX expressions for them separately.

     

    LEFT('Table'[ColumnName],2) = "11"
     
    LEFT('Table'[ColumnName],2) = "12"
     
    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi raja_94 

 

Create two roles and write below DAX expressions for them separately.

 

LEFT('Table'[ColumnName],2) = "11"
 
LEFT('Table'[ColumnName],2) = "12"
 
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.