Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with a word listing and product, I have survey free text answers in 4 separate tables based on product and survey time so I created a word frequency based on the the # of times a word is used in the sentences and I would like for the user to select that word from a visual and then see all the responses that contain that word in a new table visual. The tables have no joins. Is this possible? I tried to play with selected values and contain and nothing worked.
Solved! Go to Solution.
@Anonymous
I created a short example, please check the pbix for detail.
Keyword = IF(SEARCH(SELECTEDVALUE('Table (2)'[Key words]),MIN('Table'[Sentence]),,0)>0,SELECTEDVALUE('Table (2)'[Key words]))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@Anonymous
I created a short example, please check the pbix for detail.
Keyword = IF(SEARCH(SELECTEDVALUE('Table (2)'[Key words]),MIN('Table'[Sentence]),,0)>0,SELECTEDVALUE('Table (2)'[Key words]))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@Anonymous
Using TREATAS Function and CONTAINSSTRING Funciton you can achieve this. Try that, mean time if any sample data can help give more concrete answer
Proud to be a Super User!
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |