Row level Security DAX expression

[Anonymous]

Hi All,

Applying row level security is simple when there is just one item present in a cell. But how do you make a DAX expression for Row-Level Security when the items are comma seprated. Like in my situation, I want to apply row level security on the "Affected organizations" column where if there is "Morgan Stanley" present then only it shows to a perticular set of users.

[Anonymous · Accepted solution]

@Anonymous 
Please use containsstring function like below

CONTAINSSTRING([affected organizations],"Morgan Stanley")

Second approach is to create a calculated column 

Column = IF(SEARCH("Morgan Stanley",'Table'[Name],1,0)>0,TRUE(),FALSE())

and use this column in filter expression

[Anonymous]

thanks @Anonymous for this solutions. Works like a charm. Just to add i was also found a similar solution online and i used the following condition before saw your reply: ISNumber(Search("Morgan Stanley",Tablename[Column],,Blank()))