RLS with Numerical values based

[raja_94]

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.

[v-jingzhang · Accepted solution]

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]

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]

could you help me to write sample dax for that.

thanks,

raja.