Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
301 views
in Power BI by 16 24 32

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.


1 Answer

2 like 0 dislike
by 82 148 312
selected by
 
Best answer

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()))

count blank values in Power BI

If you don’t ask, the answer is always NO!
...