Forum Discussion
Keyword Prevalence Metric
I'm working with a workflow where there's a Product Description text field. I'd like to create a visual that shows the count of certain keywords used in the Product Description field. for example, ...
Neither would require you to edit the PBIX afterwards, if you are going to be doing a lot of this analytics then it would be worth going for the first option as you would be able to do more than just your keyword frequency analysis, it would also perform better, at the expense of your model getting slightly bigger.
If the keyword frequency analysis is all you need then you should be fine with the DAX measure only.
I have the star schema setup and I've created another table. I don't think I'm understanding how to make the new table, with delimited columns, work since the keywords are repeated in most columns.