Forum Discussion
Solved
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...
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) )
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!