Forum Discussion
Check for a Column with all null values
Hi Hoping in general to check if column contains null, one possible solution is
Is_Null_Column =
IF(
COUNTROWS(<YourTableName>) = COUNTBLANK(<YourTableName>[YourColumnName]),
"Yes:NULL",
"No:NOT NULL"
)
Did I answer your question? Mark my post as a solution! Kudos Appreciated!
Yes, that is one way to check if a column contains all null values. The `Is_Null_Column` measure you provided compares the number of rows in the table with the number of blank values in the specified column. If these two values are equal, it means that all values in the column are null, and the measure returns `"Yes:NULL"`. Otherwise, it returns `"No:NOT NULL"`.
Thank you for sharing your solution! 😊
some_bih The check for NULL / BLANKS is after filtering. How can keep the filters in the above code ?
