Managing role - contain filter

[Anonymous]

Hi everybody,

I would like to filter my data in the managing role by using a contain rather than an "=". 

Is it possible to do so? 

Thanks in advance

[VahidDM · Accepted solution]

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✌️!!

[Anonymous · Accepted solution]

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.

[VahidDM · Accepted solution]

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✌️!!