Count multiple text sections in a row with an or statement

[kduv]

Hi community, I'm new to DAX so my question may be very basic 🙂

I have a large data set similar to the below text. I need to count all the columns that have certain key words. 

Example, count all the rows that have the text "office" or "visio". I don't want it to double count rows, such as the first one that has both "office" and "visio". I want that to just be counted as 1.

Thanks in advance for any help.  

Product

Office 365, Flow,  PowerApps, visio

Office 365

Flow, PowerApps

Visio, Office 365

[Nathaniel_C · Accepted solution]

Hi @kduv ,

In Power Query try adding a conditional column. See the picture below. Not sure if a non capitalized word such as "visio" might not have to be another case. Try it. See that I added to Ifs and if there were multiple values, it still gave only 1.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[kduv]

Thanks Nathaniel... that is so perfectly simple when explained 🙂