Measure query

[Lauren]

Hi

I am trying to create a measure that will bring back the number of incidents that have "P -" at the start of the request summary. I am not sure how to use a contains or a like statement in my query. Are you able to confirm what I need to add to only return numbers of incidents that contain "P -" at the start of the summary?

Thank you  

Lauren

[Bob Dickinson]

Hi @Lauren

The following should return what you are looking for. 
This string will look for any summary that starts  with P -
 

 

Let me know if there are any issues

Kind Regards

Bob Dickinson