Filter within a Measure

[PlentyL]

Hi All,

I am writing a measure to count all records containing "director" within a job title collumn. However they all vary. Instead of using "IN", what can I use to pick up anything containing "director"?

Example of my measure below.

Thanks in advance!

[PlentyL · Accepted solution]

I have been able to do it with the below! 🙂

[milanpasschier3]

Hey man,

Maybe you could use a regular expression. This could help: https://community.powerbi.com/t5/Desktop/Filtering-a-text-column-for-a-specific-pattern/m-p/540794

Best,

Milan

[PlentyL]

Unfortunately my knowledge is quite basic and i am not familiar with custom functions or R Script :(, but thanks!