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
1.1k views
in Power BI by 24 25 33

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 158 184 366
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!
...