Forum Discussion
Count Text Data with Power BI
All, would appreciate if you could help me with my challenge. I have a table which has only text data and I like to count how many rows of data I have - if I do the "count" measure it always shows ...
How about a measure that only counts the rows with text on?
Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Text]<>BLANK()))
CountRows (on your table), exlude rows where the column does not contain text