Forum Discussion

NingMel's avatar
NingMel
Frequent Visitor
4 years ago
Solved

How to countrow with multiple values

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's avatar
    SpartaBI
    4 years ago

    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"
            )
    )
)

3 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    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's avatar
      NingMel
      Frequent Visitor
      4 years ago

      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's avatar
        SpartaBI
        Community Champion
        4 years ago

        NingMel my pleasure 🙂

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