COUNT DAX Function in Power BI
The COUNT DAX function counts the number of rows in the specified column that contain non-blank values. It also counts the duplicate values in the column.
DAX Syntax COUNT(table-name[column])
The parameter column is the column that contains the values to be counted. The table-name is optional, to avoid confusion.
Example: Lets we have the following table named Sheet1.
Let’s create a measure, with the following formula:
DAX
COUNT DAX Measure = COUNT(Sheet1[MyBranch])
The output of the above dax function is shown below:
