Power BI- Whole Count Explained

Count :

DAX COUNT function is used to count the total number of cells that contain value entities such as integer, whole number, string, and character. but not Boolean (True/False)

It's really basic DAX Function and the result is above. But don't confuse the number 44 doesn't mean there are a lot of number and their SUM is 44 this is wrong.

the number 44 Represent total number of cells entities. Don't forget it doesn't count the blank.

You can just select the Column Name

Count = COUNT(ProductSubcategory[ProductSubcategory])

COUNTA AND COUNTAX

CountA and CountAX have a one difference. CountA and CountAX functions operate TRUE/FALSE (Boolean) data type and ıf we applied CountA and CountAX function we reach out again 44.

COUNTBLANK

CountBlank functions count the number of blank cells in a column.

Count = COUNTROWS(Netflix[director])

get a example including 8809 rows. And when we applied the DAX function CountBlank, we get the result 2636 Blank value in 8809 rows.

COUNTROWS

If we applied this DAX. The result was 44. That's why we can use Countrows instead of Count because

The Count function counts the values of the column.

Countrows counts table rows

Why should we can choose Countrows ?

It is more efficient and therefore performs better.
It ignores spaces in any column of the table.
The purpose of the formula is clearer, even self-explanatory

get a example including 8809 rows.

Count = COUNTROWS(Netflix)

When we applied the CountRows function we reach out the 8809 result. and we count the table rows, not the total number of cell.

Thank you for reading and please leave a comment to become the content better one.