Word count from a sentence

mithunishad — Fri, 07 Jun 2024 07:36:29 GMT

I am trying to find the number of times particular texts appear in a description. For example if the description is " faulty item LAV-L3,LAV-L3F,LAV-L3R found". I want to count how many times "LAV-L3" was found in the text, but since LAV-L3R AND LAV-L3F also has LAV-L3 as part of the text,that is also being counted. I only want it to return count of 1. How to do it in Power Bi as DAX.

Re: Word count from a sentence

Sahir_Maharaj — Fri, 07 Jun 2024 10:49:55 GMT

Hello mithunishad,

Can you please try this approach:

ExactMatchCount = VAR SearchText = "LAV-L3" VAR SearchTextLength = LEN(SearchText) VAR Description = [YourDescriptionColumn] VAR DescriptionLength = LEN(Description) VAR CleanedDescription = SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Description, ",", " "), ".", " "), "-", " ") VAR TextParts = TRIM(CLEAN(CleanedDescription)) VAR WordCount = COUNTROWS( FILTER( GENERATESERIES(1, DescriptionLength - SearchTextLength + 1, 1), MID(CleanedDescription & " ", [Value], SearchTextLength) = SearchText && MID(CleanedDescription & " ", [Value] + SearchTextLength, 1) IN {" ", "", ","} ) ) RETURN WordCount

topic Word count from a sentence in DAX Commands and Tips

Word count from a sentence

Re: Word count from a sentence