Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
Solved! Go to 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
Hi @badger123
Based on my test, the measure is correct and you may use it with Table 2 to display the phrases.
Regards,
Cherie
@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 |
Hi @badger123
Yes,it is possible.Please check below screenshot.
Regards,
Cherie
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 |
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |