Forum Discussion

Hoping's avatar
Hoping
Icon for Helper III rankHelper III
3 years ago
Solved

Check for a Column with all null values

I wat to check if an entire column has null values and if yes, add another column with value "YES NULL" else "NO NOT NULL" repeating in DAX. ISBLANK does it for every row. But I want to check the en...
Need Help DAX
  • some_bih's avatar
    some_bih
    3 years ago

    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!

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

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!

Hoping's avatar
Hoping
Icon for Helper III rankHelper III
3 years ago

some_bih  The check for NULL / BLANKS is after filtering.  How can keep the filters in the above code ?

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Hoping the solution is for column, all rows in single column to be checked if there are NULL