Grouping all fields in a table that have a specific word in the string

[bjanzen]

I have a table that has a column that is string, with in that column I would like to grouop fields that have a word in the string.

Example:

DeviceName

Jabra 360

Mono Jabra

Built in Speakers

Stereo Jabra

I would like to group everthing that has Jabra in it.

Tried with FIND Grouped = FIND("jabra","*",Device[DeviceKey],Device[DeviceKey])

but that isnt it, and I am guessing that I cant use COUNT to find words?

Any help with this would be greatly appreciated. I am very new to DAX, but so far I am really likeing the power of it.

thanks,
Brett

[v-huizhn-msft · Accepted solution]

Hi @bjanzen,

I reproduce your scenario and get expected result, please follow the steps below.

1. Create a calculated column using the formula below, it returns "Yes" if the column has string "Jabra".

If including the string = IF(ISERROR(SEARCH("Jabra",Table3[DeviceName])),"No","Yes")

2. Create a measure to group fields that have a word in the string, and create a card visual to display it.

count = COUNTROWS(FILTER(Table3,Table3[If including the string]="Yes"))

Best Regards,
Angelia

[Greg_Deckler]

You could create a new column for it but I would use SEARCH instead of FIND. FIND does not support wildcards and is case sensitive. SEARCH doesn't have those limitations.