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?
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.
To count the blank values in your table in Power BI using DAX, you can use the below formula:
Blanks = COUNTROWS( FILTER(
'Employees'[Register Date] = BLANK()))
Most popular tags