Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
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)))
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)))
Wow,Thank you so much for your awesome suggestions.I was trying on Data Table.Thank Again
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |