RLS Security with columns that contains specific words

[Anonymous]

Hi, I'm trying to implement RLS into a Power BI report that contains specific words. I have a column that is responsible for descriptions, in those descriptions are key words that would be used to implement RLS. 

Is there any DAX I could use to implement a find or contain or if function I can use in an RLS filter?

[AlexisOlson · Accepted solution]

The function CONTAINSSTRING should work for this purpose.

An RLS filter might look something like this:

CONTAINSSTRING ( Table1[Description], "keyword" )

[Anonymous]

This is perfect! Thank you.

[DataVitalizer]

Hi @Anonymous 

Take a look here https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated