Text filtering

[Anonymous]

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

[mahoneypat]

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

[camargos88]

Hi @Anonymous ,

You can search the table 1 by keywords, however you need to define them.

Some examples can help with that.

[Greg_Deckler]

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