Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |