Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

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 "director"?

Example of my measure below.

Thanks in advance!

Need Help

Anonymous
3 years ago
I have been able to do it with the below! 🙂

3 Replies

Anonymous
Not applicable
3 years ago
I have been able to do it with the below! 🙂
milanpasschier3
Resolver I
3 years ago
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
- Anonymous
  Not applicable
  3 years ago
  Unfortunately my knowledge is quite basic and i am not familiar with custom functions or R Script :(, but thanks!

Forum Discussion

Filter within a Measure

3 Replies

Related content

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter

Measure not affected by filter

DAX MEASURE TO FILTER