Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable
      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()))