Forum Discussion
Text filtering
I am a novice to PowerBI and DAX.
I have a dataset (dataset1) with a description of medical conditions of patients written in long text.
I have a second dataset (dataset2) with a list of medical conditions I am interested in analysing.
How do I filter dataset1 to show me only patients with medical conditions listed in dataset2?
Appreciate any help.
Xwix
3 Replies
Difficult to answer with the information provided. Please share sample de-identified data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I developed this Quick Measure for a similar reason but no idea if it would fit your data:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort-AND-Slicer/m-p/391883#M130
Hi Anonymous ,
You can search the table 1 by keywords, however you need to define them.
Some examples can help with that.
Since you have two tables, you could also explore fuzzy merging in power query.
https://www.poweredsolutions.co/2019/03/26/fuzzy-matching-in-power-bi-power-query/
If you happen to have Power BI premium, you could also explore AI text analytics.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-ai-insights
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
