Forum Discussion
DAX function to count specific text values from a column
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!
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) )
3 Replies
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) )Thank you so much!
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
