Power Pivot Principles: The A to Z of DAX Functions – COUNT

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions.  This week, we look at COUNT.

The COUNT function

This function counts the number of rows in a specified column that contain any of the following kinds of values:

• numbers
• dates
• strings.

The COUNT function employs the following syntax to operate:

The COUNT function has just the one argument:

• column: this is required and represents the column (field) containing the values to be counted.

It should be further noted that:

• when the function finds no rows to count, it returns a blank
• blank values are skipped.  TRUE / FALSE values are supposedly not supported, but do note the example below
• this function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Consider the following Table called Example, with just the field, List:

Let’s create a simple measure:

Come back next week for our next post on Power Pivot in the Blog section.  In the meantime, please remember we have training in Power Pivot which you can find out more about here.  If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.