topic Re: Row level Security DAX expression in DAX Commands and Tips

Row level Security DAX expression

Anonymous — Thu, 12 Dec 2019 13:26:30 GMT

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 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.

Re: Row level Security DAX expression

Anonymous — Mon, 16 Dec 2019 05:44:59 GMT

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

Re: Row level Security DAX expression

Anonymous — Mon, 16 Dec 2019 10:19:11 GMT

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()))