DAX does not contain function for RLS Filter

[andrew_hardwick]

I am trying to create a filter for Row Level Security to check if the team contains the value "HR". We have multiple HR teams, so to ensure I capture all HR teams, I wanted to write a DAX script to say contains.

At present I can do this on a single team using the DAX below-

[Team]<>"ME HR Shared Services"

However ideally I would like it to be something like-

[Team] Not(Contain("HR")

Any ideas?

Thanks

Andy

[Peter_R · Accepted solution]

try FIND("HR", [Team], 1, -1) = -1   (to exclude any team name that contains 'HR')
or FIND("HR", [Team], 1, -1) > -1 (to only allow where the team contains "HR")

[andrew_hardwick]

Fantastic, that works exactly! Thank you.