Forum Discussion
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.
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.
3 Replies
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!!
could you help me to write sample dax for that.
thanks,
raja.
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.
