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.
Solved! Go to Solution.
@Anonymous
Please use containsstring function like below
CONTAINSSTRING([affected organizations],"Morgan Stanley")
Second approach is to create a calculated column
@Anonymous
Please use containsstring function like below
CONTAINSSTRING([affected organizations],"Morgan Stanley")
Second approach is to create a calculated column
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!