Containsstring command

[NingMel]

I'm working on this and I know this is not right.  I think I need to use Containsstring but I never use it before, seeking for some advice.  Essentially I want to count WO with EQ code that has 'PFL' within its code.  EQ code is long and 'PFL' can be included at anypart of it.

Number of WOs with EQ contain PFL =

COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CODE],"PFL"

)))

Really appreciate some directions here.  Thank you.

[NingMel]

@amitchandak Thank you so much, it works!! I use this one:

calculate(COUNTROWS(WORK_ORDER),filter(RELATEDTABLE(EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))

[amitchandak · Accepted solution]

@NingMel , Try like

calculate(COUNTROWS(WORK_ORDER),filter(RELATEDTABLE(EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))

or

calculate(COUNTROWS(WORK_ORDER),filter((EQUIPMENT), containsstring(EQUIPMENT[EQUIPMENT_CODE],"PFL")))