Can we use CONTAIN or CONTAIN STRING DAX in Row level security.

[Ruthwiksai_2021]

Hi

I have attachted the screen shot below. I have Business group column there i have semicolon values like beauty wellbeing:personal care so when i use below it is saying format error. Is there any other way acheive this rquirement.

 So my goal is the when user login they can see beauty wellbeing, personal care vaues in drop down slicer. you can see error in below screen shot.

I am using below DAX for Role

[Business Group]= CONTAINS(AD, [Business Group], "Beauty & Wellbeing") || CONTAINS(AD, [Business Group], "Personal Care")

Thanks in Advance

[ValtteriN]

Hi,

Here is one way to do this. Instead of CONTAINS you can use SEARCH:

Dax:

IFERROR(SEARCH("Personal Care",[Business Group]),FALSE())
||
IFERROR(SEARCH("Beauty & Wellbeing",[Business Group]),FALSE())

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Ruthwiksai_2021]

Hi

it is working in Power BI desktop in manage role but when i am trying in Azure analysis services it is not reflecting. it is showing all values Business group column.

I am using this below dax code in AAS.

=IFERROR(SEARCH("Personal Care",DimCategory[Business Group]),FALSE()) || IFERROR(SEARCH("Beauty & Wellbeing",DimCategory[Business Group]),FALSE())