Count Text Data with Power BI

[TheQ1982]

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 the total in each line, but I like to have each line counted as one (1).

With that data I like to compare the number of shipments YTD 2021 vs. 2022 in another measure to receive the growth percentage YOY.

[PurpleGate]

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