Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 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.

Need Help

1 Reply

  • PurpleGate's avatar
    PurpleGate
    Resolver III
    4 years ago

    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