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
in Power BI by 5 9 22

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

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 60 125 265
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:

        'Employees'[Register Date] = BLANK()))

count blank values in Power BI

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