Forum Discussion

Revilo's avatar
Revilo
Regular Visitor
3 years ago

Column with data separated with semicolon

Hi,

 

Just want to ask, I have a column in one of my table with format shown below. Is this an array? I am interested in counting rows with blank specific string within that array.

 

Ex. 

I am interested only with "followups", if its not present then I will count that specific record with no string of "followups".

 

 

 

3 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

    =COUNTROWS(FILTER(TABLE,SUMX(Array,FIND(TABLE[Equipment],Array[Col],,0))=0))

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Revilo 
    I hope it is as simple as it is described by the given example. Please let me know if it is not. For now please try

    =
COUNTROWS (
    FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[Equipment], "followups" ) )
)
    • Revilo's avatar
      Revilo
      Regular Visitor
      3 years ago
      =
COUNTROWS (
    FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[Equipment], "followups","appliances", "clothing" ) )
)

      can i add more strings in that parameter like the shown above? thanks