Distinct count of blank values in visual

[Anonymous]

I'm trying to count distinct blank cell in visual table. I have tried this 

DISTINCTCOUNTNOBLANK('STOs Visibility'[Planned ETA])+COUNTBLANK('STOs Visibility'[Planned ETA])

But it doesn't seem to count distinct values. Any help is much appreciated. 

[v-yinliw-msft]

Hi @Anonymous ,

I am a little confused, what do you mean the distinct blank cell?

You mean “” or there is nothing in the cell?

Or you just want to know the numbers of all the blank cells in a table?

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Is there another method of counting distinct blank values? I count dictinct value when a value is present, but want to count the blank that are distinct. 

[daXtreme]

Once again... There are no different distinct blank values. You cannot distinguish among blanks.

[daXtreme · Accepted solution]

"I'm trying to count distinct blank cell in visual table."

Hm... interesting. As far as I know, there's only one type of BLANK in DAX, so the answer will always be... 0 or 1. Two BLANKS are equal, so.... you can't have more than 1 distinct blank cell.