Forum Discussion

lamp38's avatar
lamp38
New Member
7 years ago

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Sounds like an interesting one to solve.  Share some data and show the expected result.  Especially show cases where the feedback string has multiple key terms and your expected result for those cases.

  • lamp38's avatar
    lamp38
    New Member
    7 years ago

    Imagine we have the following rows: 

     

    1. Complaint 1: "App is very slow." 
    2. Complaint 2: "App loads slowly." 
    3. 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
    • AlB's avatar
      AlB
      Community Champion
      7 years ago

      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 )
    )