How to countrow with multiple values

[NingMel]

I have this:

WO with Code TF1 = COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CATEGORY_CODE] , "TF1") ))

WO with Code TF2 = COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CATEGORY_CODE] , "TF2") ))

I want to use just one command (combine them together).  I want to count WO if it has EQUIPMENT[EQUIPMENT_CATEGORY_CODE] either TF1 or TF2.  I tried below but it doesn't work.

COUNTROWS(

FILTER(

WORK_ORDER, CONTAINS(RELATEDTABLE(EQUIPMENT), EQUIPMENT[EQUIPMENT_CATEGORY_CODE]  in { "TF1", "TF2" } ) ))

Any suggestions?

[SpartaBI · Accepted solution]

@NingMel try this:

WO with Code TF1 or TF2 =
COUNTROWS (
    FILTER (
        WORK_ORDER,
        CONTAINS (
            RELATEDTABLE ( EQUIPMENT ),
            EQUIPMENT[EQUIPMENT_CATEGORY_CODE], "TF1"
        )
            || CONTAINS (
                RELATEDTABLE ( EQUIPMENT ),
                EQUIPMENT[EQUIPMENT_CATEGORY_CODE], "TF2"
            )
    )
)

[NingMel]

@SpartaBI Thank you so much it works!!!  I knew it was something to do with this || but I never use it before.  I tried below but it didn't work.  Anyway thank you so much.

EQUIPMENT[EQUIPMENT_CATEGORY_CODE] in { "TF' ,"TF2"}

[SpartaBI]

@NingMel my pleasure 🙂

Please don't forget to accept my previuos reply as a solution for community viasabilty and appreciate your kudos 🙂