Forum Discussion
Solved
Formula to count occurences of text string in DAX
I have the following formula to count the occurrences of the word "forum" in a column (L with Comment header). =COUNTIF($L$2:$L$4000,”*forum*”) It should count the word occuring in any part ...
Such a measure could like something like this:
=SUMX(AllResults,IF(CONTAINSSTRING ([Comment], "forum"),1,0))
Such a measure could like something like this:
=SUMX(AllResults,IF(CONTAINSSTRING ([Comment], "forum"),1,0))
Thanks very much. This works perfectly... unfortunately the measure doesn't seem to exist in Excel 2016, but I got it working in Power BI.