Count multiple strings in a column

Hello @pal95 ,

You will need to split your column into multiple columns in the query editor as shown in this blog:

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

You can then count the occurrences of a string in multiple columns that reference the following existing thread:

https://community.powerbi.com/t5/Desktop/Count-instances-of-string-in-multiple-columns/td-p/239302

Thank you

Pragati

@pal95

in the pq, split column

then group by