count blanks by row

[quinncode]

How do I count blank values by row in a custom column with DAX?

[NidhiBhusari]

@quinncode use COUNTBLANK() DAX function to get count of blank values(rows) in a column.

[quinncode]

DOGS	CATS	BLANKS
dog		1
	cat	1
dog	cat	0

Thanks, however I need a count of blanks at the row level like table above

[HashamNiaz · Accepted solution]

Hi @quinncode !

You can use following DAX to create a custom column which will add blank occurences in Dogs & Cats columns.

Blank = IF(ISBLANK(Pet[Dogs]) || Pet[Dogs] = "", 1, 0) 
        + IF(ISBLANK(Pet[Cats]) || Pet[Cats] = "", 1, 0)

Regards,

Hasham

[quinncode]

Thank you! Perfect answer.