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 of the text (e.g. "thank you for inviting me to the forum", "goodforum" [sic])
I would like to replicate it with DAX to use in a Power Pivot table. I have tried the following measure that I found on an earlier post, however the numbers counted seem much lower.
=SUMX(AllResults, 1*(FIND(“forum”, ALLResults[Comment],,0)>0))
Any advice would be appreciated.
Such a measure could like something like this:
=SUMX(AllResults,IF(CONTAINSSTRING ([Comment], "forum"),1,0))
2 Replies
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.
