Forum Discussion

julienvdc's avatar
julienvdc
Icon for Helper III rankHelper III
5 years ago
Solved

Count appearance of string in a comma-separated data column

Hey there,   I have a table with a list of strings as so: String A String B String C String D String E String F   Then I have another table with a column that lists a series...
Tips and Tricks
  • parry2k's avatar
    parry2k
    5 years ago

    julienvdc you can add a Column using this

     

    Count of Rows = 
VAR __dataToFind = Data[Column1]
RETURN
CALCULATE ( COUNTROWS ( List ), CONTAINSSTRING ( List[Column1],  __dataToFind ) )

     

     

    and here is the output:

     

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

    following expression. Change table and column name as per your model:

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

julienvdc you can add a Column using this

 

Count of Rows = 
VAR __dataToFind = Data[Column1]
RETURN
CALCULATE ( COUNTROWS ( List ), CONTAINSSTRING ( List[Column1],  __dataToFind ) )

 

 

and here is the output:

 

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

following expression. Change table and column name as per your model: