Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |