Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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