Forum Discussion

TaufikMaggangka's avatar
TaufikMaggangka
Icon for Helper II rankHelper II
5 years ago
Solved

Count specific text in one column with direct query mode

Hi all, I need help to create measure to count number of specific text that contains in one column, please note that I using direct query mode on connecting to database. Here my illustration, I...
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    You can create a measure with below code

    word_count = 
LEN ( MAX ( 'Table (5)'[Cough Fever] ) )
    - LEN ( SUBSTITUTE ( MAX ( 'Table (5)'[Cough Fever] ), " ", "" ) ) + 1

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
5 years ago

You can create a measure with below code

word_count = 
LEN ( MAX ( 'Table (5)'[Cough Fever] ) )
    - LEN ( SUBSTITUTE ( MAX ( 'Table (5)'[Cough Fever] ), " ", "" ) ) + 1