Forum Discussion

NJ13's avatar
NJ13
Helper I
4 years ago
Solved

Count if

Hello All,  I need some help please, I want to calculate using count if for a text column, i have a column with words such as boy ; girl ; child ; family ; And ; model and different other combinatio...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi @ ,

     

    You can create a measure like this:-

    Measure =
CALCULATE (
    COUNT ( 'Table'[Column1] ),
    CONTAINSSTRING ( 'Table'[Column1], "boy" )
)

     

    Thanks,

    Samarth

NJ13's avatar
NJ13
Helper I
4 years ago

thank you so much, how about if i want multiple strings?

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    You can try like:-

    Measure =
CALCULATE (
    COUNT ( 'Table'[Column1] ),
    CONTAINSSTRING ( 'Table'[Column1], "boy" ) ||
    CONTAINSSTRING ( 'Table'[Column1], "girl" ) ||
    CONTAINSSTRING ( 'Table'[Column1], "child" 
)