DAX function to count specific text values from a column

[BeckyPeppin]

I have a column of text that I need to count specific text.  Here is a small sample:

Classification

Injury

Environmental;Near Miss

Injury;Environmental

Near Miss; Injury

Near Miss

Equipment Damage

I need help with a formula that will count Near Miss from the Classification Column.  In the data sample above, I'd expect Near Miss to count 3 times.

I'm sure this is simple, but for some reason I can't get it!

[Phil_Seamark · Accepted solution]

Hi @BeckyPeppin

Is this along the lines of what you need?

It's a calculated measure

My Count = CALCULATE(
		COUNTROWS('Table3'),
		SEARCH(
			"Near Miss",'Table3'[Classification],,0)
			)

[CAPEconsulting]

I am doing something similar and have 2 options

Asthma Prev = CALCULATE(COUNT(Epi[asthma active]),Epi[asthma active] = "true")/COUNT(Epi[ID])

or

Asthma Prev = CALCULATE(COUNTROWS(Epi),Epi[asthma active] = "true")/COUNT(Epi[ID])

Both give the same answer. Could you tell me the differences in the 2 apparoaches and which one to go for.

Also Asthma Prev = CALCULATE(COUNTA(Epi[asthma active]),Epi[asthma active] = "true")/COUNT(Epi[ID]) is alsoe giving me the same answr. ALL 3 OPTIONS SEEMS TO WORK. Butnot sure which one is BEST

[BeckyPeppin]

Thank you so much!