Creating a visual using several filters

Hi Anonymous,

You might want to create a calculated column named IsMissingData in the table, that checks rows for missing column data. The calculated column checks every required column for missing values. If any required column is missing data, you can set the column value to TRUE. You can use this column to show any rows with missing data.

IsMissingData =
VAR colA = IF(ISBLANK([Column A]), TRUE, FALSE)
VAR colB = IF(ISBLANK([Column B]), TRUE, FALSE)
VAR colC = IF(ISBLANK([Column C]), TRUE, FALSE)

RETURN
  AND(AND(colA, colB), colC)

You can also create a create a calculated column named NumberOfColumnsMissingData in the table, that counts the number of required columns that are missing data.

NumberOfColumnsMissingData = 
VAR colA = IF(ISBLANK([Column A]), 1, 0)
VAR colB = IF(ISBLANK([Column B]), 1, 0)
VAR colC = IF(ISBLANK([Column C]), 1, 0)

RETURN
  colA+colB+colC

Hope this helps. If so, please give a Kudos 👍 and mark as Accepted Solution ✔️.