Forum Discussion
Filter within a Measure
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 "...
I have been able to do it with the below! 🙂
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
Unfortunately my knowledge is quite basic and i am not familiar with custom functions or R Script :(, but thanks!