Forum Discussion

njxfoster's avatar
njxfoster
Icon for Helper I rankHelper I
4 years ago
Solved

How to If text column CONTAINS specified value, Then Count it

Hi Everyone,

 

I'm trying to create a calculated measure in one of my tables that help me count every column that contains the word "Warm".

 

How can I implement CALCULATE(COUNTROWS to achieve this function? 

 

 

Thank you!

Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    njxfoster,

     

    Try this measure:

     

    Warm Count = 
CALCULATE (
    COUNT ( Table1[Label] ),
    FILTER ( Table1, CONTAINSSTRING ( Table1[Label], "Warm" ) )
)

     

    Data:

     

     

    Result:

     

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    4 years ago

    njxfoster,

     

    Try this measure:

     

    Warm Count = 
CALCULATE (
    COUNT ( Table1[Label] ),
    FILTER ( Table1, CONTAINSSTRING ( Table1[Label], "Warm" ) )
)

     

    Data:

     

     

    Result: