Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not 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.

 

Power BI screenshot.JPG

 

power BI screenshot 2.JPG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Anonymous 
Please use containsstring function like belowRLS.png

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@Anonymous 
Please use containsstring function like belowRLS.png

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.