Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.


How to Think Like a Certification Exam at the PASS Professional Development Virtual Group


Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?


Recently I ran into an error when trying to copy a small database bacpac...

Daily Coping–3 Apr 2020


I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs


Replacing / Removing All Text In Multiple Sets of Characters in SQL

By mnovosel

One of the result fields has multiple html references in it such as in...

steps testing and moving workloads from SQL Server 2014 to SQL Server 2019

By sqlguy80

Hello, SQL Server Gurus, Can any one please suggest  steps regarding performance testing all workloads...

Causes for The query processor could not produce a query plan

By YSLGuru

SQL Server 2016 (13.0.5598.27) The first version of the below query produces results while...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers