cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
owa99 Visitor
Visitor

Search table of strings based on selected keyword

Hello,

I have tried the other solutions on here with no luck.  I see solutions using COUNTX, COUNTROWS, as a Measure, but my attempts at implementing these never worked.

I would like to select a Keyword in a keyword table, and then display each row whose string contains the selected keyword in a conversations table.

If I select, "Apple," I would like to see "I like apples," "apples are good" in the conversations table.

Here's what I wish I could do in psuedocode:

FilteredConvos = FILTER(Conversations[conversations], "String in row contains SELECTEDVALUE(Keyword[keyword]")

Any help is appreciated!

1 REPLY 1
AClerk New Contributor
New Contributor

Re: Search table of strings based on selected keyword

Hi @owa99 

You can create a new measure on your table.

Then use the keywords table as a slicer.

T17 is my strings table.
T18 is my keywords table.

Exist = 
VAR searched_value =
    SEARCH (
        SELECTEDVALUE ( T18[Dictionary] ),
        SELECTEDVALUE ( T17[String] ),
        ,
        BLANK ()
    )
RETURN
    IF (
        searched_value > 0,
        "Exist"
    )

Dynamic_Filter.gif

 

Thanks!
A

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 158 members 1,644 guests
Please welcome our newest community members: