How to COUNT in Power BI // COUNT, COUNTA, DISTINCTCOUNT, COUNTBLANK, COUNTROWS, COUNTX, COUNTAX

In this video I go through the SEVEN different ways you can count using DAX in Power BI.

Counting is probably one of the most common functions you would've been using if you work a lot of with data. Did you know that you can do more with your COUNTS in Power BI?

Here's a TLDR version of the video if you don't want to watch the whole thing:
- COUNT - Count Non-Blank Values
- COUNTA - Count Non-Blank Values, accepts TRUE/FALSE types
- DISTINCTCOUNT - Count unique values
- COUNTBLANK - Counts blank rows
- COUNTROWS - Counts rows in table
- COUNTX - Count rows with expression (like Filters)
- COUNTAX - Count rows with expression, accepts TRUE/FALSE types

-

Get started with Power BI Desktop FREE

Generate mock data with Mockaroo

SUM and SUMX in Power BI

AVERAGE and AVERAGEX in Power BI

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[sixtyfiveroses]

Perfect explanation, just what I was looking for! I've watched many videos, but no one explains it the way you did. Thank you again! Subscribed.

[aidakalantari]

Very clear explanation. Good job and thank you for sharing

[faizaa]

Such a good video, slowly starting to become a pro on power bi. THANK YOU SO MUCH!

[bouldy]

Thank you for the Countx Filter measure! Hero

[EMKworks]

Excellent layered 10 minute video, being able to see the table and the counted numbers on the one page seriously good idea. Well done!

[matthewshotton]

Amazingly explained for the refresher I needed, thanks for all the great content!

[danielosorio]

Excellent explanations! I'd like to know how to use the functions, particularly using CountX and CountAX to count "text" values (non Boolean) rather than numerical.
I have a table with vendors/suppliers that deliver different parts. Some of the vendors deliver some of the same parts, so two vendors may have the same Part No..
Parts per vendor are marked as delivered Early, On-time, and Late. I want to count each of these three delivery statuses per part and vendor to then calculate the percentage of each delivery status per vendor out of the Grand Total of all deliveries and the percentage based on each delivery type/status. For now, this is the formula I came up with to count early deliveries:

_CountX = COUNTAX(FILTER(Delivery, Delivery[Delivery Type] = Early()), Delivery[Delivery Type])

Thanks for your help!

[ibrahimburhankonuk]

Perfect explanation, worth to watch for every sec.

[cazvon]

Clearly explained supported by simple visuals - makes learning less complicated. One question, why would you not use the COUNTA and COUNTAX functions all the time as they can handle numeric, text and binary strings? Is it a refresh performance issue?
Thank you.

[Devloper]

Perfect and practical explanation about the count function !!! Thank you brother

[faizanbhat]

count function calculates blank cells as well for me.

[jevieacop]

Hey Fernan! Thanks for your videos, I've been following you for quite a while now and it helps me a lot in my work related projects. Are you a Filipino?

[gnavarrolema]

Great explanation...it is much clear to me how to use these functions. Thanks.

[Pasar]

Great video! I have a question. Why if we want to count everything in the row except a specific value?

[davidgitau]

MeasureName=CountRows(CalculateTable(Table, Filter1, filter2))--CalculateTable gives you an opportunity return a subset of the table, with rows that meets criteria specified in the filters. Then use countrows to get subset count,

[mayanknema]

Awesome explanation. You cant get better than this on this topic.

[anino]

Great explanation.... Maybe you can help me with a matter, I need to count the codes of the clients that are repeated during different years. For example, customer 373 checked in 2020, 2021, 2022 = 3 unique times. Thanks for your help.

[giridharnaidu]

What are the most common DAX functions used in power bi in real time.. Can u cover a video in this specific topic..

[kayeiaramariedeocampo]

Great Video! One question, what if I want to count the number of occurence of a specific Order ID?

[MoonShine-bscl]

Hi your teaching is great but how can i avail the pbix demo files which u have used in the videos for practice, please help.