Count Blank Values in a Column

[Anonymous]

Hi Experts

I am trying to count the number of blank values in my table based on another column

Blank Values = CALCULATE(

COUNTROWS('STG Fact_To_Do'),

'STG Fact_To_Do'[Created_Date]=BLANK(),

FILTER('STG Fact_To_Do',ISBLANK('STG Fact_To_Do'[Closed]

So if the Created Date Column has blank rows based on the closed column which always has a value in - count the blank cells in Created date column

See Example Data - here we have 3 blank rows...

Created_Date	Closed
14 August 2020	1
	1
23 July 2020	1
19 August 2020	1
	1
28 July 2020	1
	1
22 November 2019	1
20 August 2020	1

[VijayP]

@Anonymous  

Count = CALCULATE(COUNTROWS('Table (2)'),FILTER('Table (2)',ISBLANK('Table (2)'[Created_Date])))

Try this 

Regards

Vijay Perepa

[Anonymous]

HI Vijay

I am getting blank result in  score card....not the value 3

[VijayP]

@Anonymous 

Please find tjhe attached file

https://drive.google.com/file/d/1Knkn7OtNHejWJ1lllVDgQ9TN-cdrm4fI/view?usp=sharing

[amitchandak]

@Anonymous , I was able to get 3 . Posted file in last update

[Anonymous]

Ok i forgot to mention my FACT Table TO DO links to a DIM Date table (1 to *) relationship Date to Created Date (FACT Table). i am still getting blank values???

[amitchandak]

@Anonymous ,

+0 to a measure and count zeros. Can you share the complete sample?

[Anonymous]

Hi AMit

I cannot upload a file nor send a drobox link. If you create a simple DIM Date Table and link DAte from Dim DAte to Created Date in FACT table and see if the measure works

[VijayP]

@Anonymous 

Then Formula will be calculate(countrows(facttable),filter(all(datestable),isblank(datesinfacttable))

[amitchandak]

@Anonymous , Try like

countrows(filter('STG Fact_To_Do', isblank(Created_Date)))

or

calculate(countrows('STG Fact_To_Do'),filter('STG Fact_To_Do', isblank(Created_Date)))

[Anonymous]

Both DAX formula return back blank as oppsed to the value 3

[amitchandak]

@Anonymous , Please find the find attached after signature