Forum Discussion
Count of Rows which Contain Term?
This seems like it should be really simple, but I'm having a difficult time finding the answer. I have a bunch of survey responses from from an testing group that I want to organize: One o...
Imagine we have the following rows:
- Complaint 1: "App is very slow."
- Complaint 2: "App loads slowly."
- Compaint 3: "The app was very slow, and then crashed."
I have to be able to summarize the data as follows:
- Count (slow) = 3
- Count (crashed) = 1
Hi lamp38
Try this:
1. Create a one-column table Terms in which you have the terms you want to look for
2. Place Terms[Term] on the rows of a matrix visual
3. Place this measure in values of the matrix:
Measure =
VAR _CurrentTerm =
SELECTEDVALUE ( Terms[Term] )
RETURN
COUNTROWS (
FILTER ( Table1, FIND ( _CurrentTerm, Table1[feedback string], 1, 0 ) > 0 )
)