Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

COUNT IF Containts Key Word

Hi all,

 

How do I create a measure whichs Counts 'Ref' IF 'Contact Tags' contains the key words "Hiring Contact"?

 

Thanks,

 

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try like

    countx(filter(table,table[Contact Tags]="Hiring Contact"),table[Contact Tags])

countx(filter(table,table[Ref]="Hiring Contact"),table[Contact Tags])
  • Anonymous's avatar
    Anonymous
    6 years ago

    HenryJS 

     

     

    Measure = CALCULATE(COUNT(Table1[Ref]),FILTER(Table1,[Contact Tag] ="Hiring Contact"))

     

    Btw I see "Hiring contact"in [Type], so can also try:

    Measure = CALCULATE(COUNT(Table1[Ref]),FILTER(Table1,[Type] ="Hiring Contact"))

     

    Paul Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Try like

    countx(filter(table,table[Contact Tags]="Hiring Contact"),table[Contact Tags])

countx(filter(table,table[Ref]="Hiring Contact"),table[Contact Tags])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HenryJS 

     

     

    Measure = CALCULATE(COUNT(Table1[Ref]),FILTER(Table1,[Contact Tag] ="Hiring Contact"))

     

    Btw I see "Hiring contact"in [Type], so can also try:

    Measure = CALCULATE(COUNT(Table1[Ref]),FILTER(Table1,[Type] ="Hiring Contact"))

     

    Paul Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.