Search, Filter, and Create a new table from the result, DAX

[Ethel_007]

Please read patiently as I explain my current challenge. I am currently working with PowerBI, and I would like some help with a current task, I think might involve DAX, but I am not so sure. BackgroundInfo: I have a table called "Main_File". This table contains 7 columns, but I am only interested in the contents of just 3 columns which are called: "ShortDescription", "LongDescription", and "ProblemSolution". The contents of this columns are various texts. Challenge: I want to filter these 3 columns based on some specific keywords. That is, How can I search through every row in these columns for the occurrence of one or more keywords, and filter out the rows that have these keyword(s) Example: Let the contents of one row in the table ("Main_File") have the following contents in the 3 columns I am interested in:

1. ShortDescription = "Alert of an unknown computer for the power point app"
2. LongDescription = "User received an alert on his Power Point Application"
3. ProblemSolution = "Alert disabled and the application works perfectly"

My keywords: "PowerPoint", "power point", "Power-Point"
What I have done:

• I have used "Conditional Columns, but the result were not optimal.

=========================================
Your kind assistance and prompt response would really help an intern alot.

[v-shex-msft]

Hi @Ethel_007,

Current power bi not support to create dynamic calculate column/table based on slicer and filters.

Please take a look at following link to know more about this limitation.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,

Xiaoxin Sheng