Unstructured Data Word Count

[tejapowerbi123]

Hello Community,

Please review below and provide your guidance.

My data table has unstructured  data and also Look up table.

Requirements:If lookup table words matches with Data Table then if should count words in a new table or in Data Table.

I am not able to figure it out how to procedd?

Once i have word count it is going to use on bar chart (Example:Bar for Financail Analysis=2,Food Analysis=1)

Data Table

Comments

Financial Analysis & Health Analysis is very Important

Food Analysis & Financial Analysis is very Important

Lookup Table

Financial Analysis

Health Analysis

Food Analysis

Result Table
Column_1	Word_Count
Financail Analysis	2
Health Analysis	1
Food Analysis	1

[az38 · Accepted solution]

Hi @tejapowerbi123 

add a measure into your Lookup Table

Measure = 
var _lookupValue = MAX('Lookup Table'[Lookup Column])
RETURN
CALCULATE(SUMX('Data Table', IF(SEARCH(_lookupValue,'Data Table'[Comments],,0) > 0, 1, 0)))

[tejapowerbi123]

Wow,Thank you so much for your awesome suggestions.I was trying on Data Table.Thank Again