Text search

Hello there Ara_Karapetyan ! I think it would be best for you to perform these actions in Power Query rather than a measure. Open the Query Editor and add a custom column. In the pop up window paste the following code.

Try this for the category column:

=let myvalue=[Search string]
in
Text.Combine(
    Table.SelectRows(SecondTable,
each Text.Contains(myvalue,[Name]))[Category]
,
",")

 And this for the group:

=let myvalue=[Search string]
in
Text.Combine(
    Table.SelectRows(SecondTable,
each Text.Contains(myvalue,[Name]))[Group]
,
",")

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes