Counting NonBlank Cells across multiple columns

Anonymous

Not applicable

6 years ago

Thank you very much for your quick response. This is appreciated.

I actually do need the splitting in the multiple columns hence this request.

When I copied and edited the syntax you suggested, it gave me some error. Please see the screenshot below

I think the error is from second to last step of the formula (ISBLANK([Column]))):

MC Count Blank =

VAR tmpCol1 = SELECTCOLUMNS(MAD,"Column",[Please mention all the food your child ate between yesterday and now, Day&Nigh.1])

VAR tmpCol2 = SELECTCOLUMNS(MAD,"Column",[Please mention all the food your child ate between yesterday and now, Day&Nigh.2])

VAR tmpCol3 = SELECTCOLUMNS(MAD,"Column",[Please mention all the food your child ate between yesterday and now, Day&Nigh.3])

VAR tmpCol4 = SELECTCOLUMNS(MAD,"Column",[Please mention all the food your child ate between yesterday and now, Day&Night.])

VAR tmpTable = UNION(UNION(UNION(tmpCol1,tmpCol2),tmpCol3),tmpCol4)

VAR tmpValue = COUNTROWS(FILTER(tmpTable,ISBLANK([Column]))

RETURN tmpValue

Forum Discussion