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.
VahidDM's avatar
VahidDM
Super User
4 years ago

Hi raja_94 

 

Use LEFT DAX to find 2 characters from the start of a text string in your first column in the image.

Then Add 2 roles for 11 and 12, and after that, add members to those 2 roles.

 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

raja_94's avatar
raja_94
Frequent Visitor
4 years ago

could you help me to write sample dax for that.

 

thanks,

raja.