Forum Discussion
Anonymous
6 years agoNot applicable
Row level Security DAX expression
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.
- Anonymous6 years ago
Anonymous
Please use containsstring function like belowCONTAINSSTRING([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
2 Replies
- AnonymousNot applicable
Anonymous
Please use containsstring function like belowCONTAINSSTRING([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- AnonymousNot applicablethanks 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()))