Managing role - contain filter

Hi Anonymous 

Please see these links:

https://docs.microsoft.com/en-us/dax/contains-function-dax

https://docs.microsoft.com/en-us/dax/containsstring-function-dax

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

Hi Anonymous ,

1.If you want to filter multiple users, you could use

IN {"UserA", "UserB","UserC"}

to replace

="UserA" 

2. If you want to check whether a vakue contains a specific string, you could use CONTAINSSTRING() or FIND() or SEARCH()

Measure = IF(CONTAINSSTRING(MAX('Table'[Value]),"Power BI"),1,0)

Measure = FIND("Power",MAX('Table'[Value]),,0)

Measure = SEARCH("Power",MAX('Table'[Value]),,0)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.