Search measure & cross-filter

[badger123]

Hi all,

I have two table visuals: one is displaying phrases from Table 2, another is displaying terms from Table 1 with another column using measure CountWords (below), counting the frequency of each term appearing in the phrases. Is it possible at all that I can make it so that when I select a term it filters the phrases in the other table to show those that contain the selected term? 

CountWords = 
VAR CurrWord =
SELECTEDVALUE ( 'Table1'[term] )
RETURN
COUNTROWS (
    CALCULATETABLE (
        VALUES ( Table2[phrase]),
        FILTER ( Table2
        , SEARCH ( CurrWord, Table2[phrase], 1, -1 ) > 0 ) ))

I'm not sure if this is possible but happy to change my approach if it is using different measures. Any guidance would be appreciated 🙂 

[v-cherch-msft]

Hi @badger123 

Based on my test, the measure is correct and you may use it with Table 2 to display the phrases.

Regards,

Cherie

[badger123]

@v-cherch-msft Thanks Cherie! The measure works fine, but I would like it so that when I click on a term in my table visual, it filters the other table visual with the phrases. E.g. say the table visual looked as below, if I click "Oranges" in the term table, I would like only the phrases containing "oranges" to display in the phrase table. Is this possible?

Phrase

I like oranges

I don't like oranges

I like apples

I don't like apples

Term

Oranges

Apples

[v-cherch-msft]

Hi @badger123 

Yes,it is possible.Please check below screenshot.

Regards,

Cherie

[badger123]

Thanks for your help @v-cherch-msft , you are right! That does work. The reason it's not working for me is because I am searching for "term" but I want to put "select" in a table and use this to filter (see below). Is this possible? 

Select	Term
Apples	Apple
Apples	Apples
Oranges	Orange
Oranges	Oranges

[v-cherch-msft · Accepted solution]

Hi @badger123 

Based on my test, you may put Term in table visual.But you may also need put the measure in it.

Regards,

Cherie