Power BI Blank Values Count

Question

I have a table in Power BI with a column that holds blank values, and I need to know How many rows has blank value in this column using DAX in Power BI, How can I do that?

Employee	Register Date
Marko	12-12-2022 12:00 PM
Jan
Pedro

In the above table, I need to know how many users didn't have value and get the employees count who didn't register yet.

Answer 1

Count Blank Values in Power BI

To count the blank values in your table in Power BI using DAX, you can use the below formula:

Blanks = COUNTROWS( FILTER(
        'Employees',
        'Employees'[Register Date] = BLANK()))