count null observations

[iiasadw]

Hi,

I would like to calculate the number of null observation in each of my columns (except for one column) and then filter by that column.

E.g.

Table:

Col1                    Col 2            Col 3             NonNull Col

abc		bbb	1
	aaa		2
bca			3

Result:

NonNull Col	3	<- value in non null col
No. of Blank Cells	2	<- Count of null values per row

Is there a way to do this that does not involve creating a metric for each column?

Thanks!

[v-yuta-msft]

@iiasadw ,

---

@iiasadw wrote:

Hi,

I would like to calculate the number of null observation in each of my columns (except for one column) and then filter by that column.

E.g.

Table:

Col1                    Col 2            Col 3             NonNull Col

abc		bbb	1
	aaa		2
bca			3

Result:

NonNull Col	3	<- value in non null col
No. of Blank Cells	2	<- Count of null values per row

Is there a way to do this that does not involve creating a metric for each column?

Thanks!

---

Could you please explain why the "Count of null values per row"  is always 2? Could you please format the sample table?

Regards,

Jimmy Tao