Forum Discussion
Solved
Counting words in a column
A table contains a column with 7188 rows. Each row contains a short phrase or a single word. I want to go through row by row and see how many times a phrase appeared. Like how many times did "house c...
If you use the key phrase column as your row headers in a matrix and create the below measure
Key Phrase Count =CALCULATE( COUNTROWS( PhraseTable))Put the measure in your matrix and that should be good.
I don't know if it is possible also in DAX, but using only a function in PQ,
starting from this data table
you can get this result:
If you use the key phrase column as your row headers in a matrix and create the below measure
Key Phrase Count =
CALCULATE( COUNTROWS( PhraseTable))
Put the measure in your matrix and that should be good.
