COUNTA DAX Function in Power BI
The COUNTA DAX function counts the number of rows in the specified column that contain non-blank values.
Example: Lets we have the following table named Sheet1.
Let’s create a measure, with the following formula:
DAX
COUNTA DAX Measure = COUNTA(Sheet1[MyBranch])
The output of the above dax function is shown below:
