Count not empty rows only

(0) Share

Report

Posted on by CharlesBrewer

674

Hello,

So I am trying to count the not empty rows in a particular column, "Bendix". I have the following, which I am unsure if it is correct but the data shows and there is no error? (I have to blur out the data because it is software keys)

The count is however showing all rows, even empty ones. I've tried it a few ways to insert like IsEmpty but I can't get it to work, any tips?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (4)

Report
Hi @CharlesBrewer ,

Try

CountRows( Filter( Laptops.AllItems, !IsBlank(Bendix) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
Hi @CharlesBrewer

You could also consider calling the CountA function, since the specific purpose of this is to count non-blank rows.

https://learn.microsoft.com/en-gb/power-platform/power-fx/reference/function-table-counts

CountA(Laptops.AllItems.Bendix)

Was this reply helpful? Yes No
CharlesBrewer 674 on at

Like (0)

Report

Thanks for the responses guys. I tried both, Warren's work, the CountA did not however, it still counted the blank ones for some reason.

Was this reply helpful? Yes No