Count Column A if Column B has no date

[Patman]

Please advise, Trying to count A where B date fields are blank. Cannot do a replace Null  with 'No Date' in the data table as this is not available in date formats.

Count({<[Open/Closed/Void]={'Open','Eff-Check'}>}[Open/Closed/Void] and [Planned Closure Date]-='*')

[arulsettu]

Maybe like this

Count({<[Open/Closed/Void]={'Open','Eff-Check'},[Planned Closure Date]-={' '}>}[Open/Closed/Void])

[Patman]

Unfortunately this solution is not working for me.

[arulsettu]

Do you have the null values in [Planned Closure Date]?

Can you share the sample app with expected output

[Patman]

Cheers, Yes I have null values in the date column (that is the real problem)

I will try to put a small app together and forward.

Kind Regards

Patman