Skip to content
Infoveave Help

COUNTNOBLANK

The COUNTNOBLANK function calculates the number of non-blank or non-null cells or entries in a column. It counts the cells or entries that contain data.

Applicable to

  • Calculated Columns
  • Expressions

Return Value

The return value of the COUNTNOBLANK function is an integer representing the count of non-blank or non-null cells or entries in the specified column.

Remark

  • COUNTNOBLANK is a valuable function for assessing data completeness and identifying the presence of data within a specific column.
  • COUNTNOBLANK function returns the total count excluding nulls and blanks.
  • COUNTNOBLANK function can be used across Dates, Strings, and Numbers.

Syntax

COUNTNOBLANK(<expression>)

COUNTNOBLANK in Board Expression

Parameters

ExpressionA placeholder in a function that is replaced with the actual widget and measure names.
Widget NameThe specific name or identifier of the widget being used for data visualization in the specific Infoboard.
MeasureRepresents the name of the measure that is being displayed or analyzed using the widget.

Steps to Use COUNTNOBLANK

  1. Write the COUNTNOBLANK function. For instance COUNTNOBLANK<expression>
  2. Replace <expression> with 'Widget Name'[Measure].Replace Widget Name with the actual name of your widget and Measure with the corresponding measure name.
  3. Set the condition with the COUNTNOBLANK function based on the scenario. For instance, you can set the count of non-blank or not-null entries that meet a certain criterion, as the condition.
  4. To learn how to configure an Expression in Infoveave, visit the section Configure Expression.

Scenario

  • Imagine you are managing a Consumption Dashboard, and one of your key objectives is to ensure the data within it is complete and accurate. Specifically, you want to count the number of non-blank entries in the ‘Customers’ column of your dataset continuously. If this count ever reaches 20, you want to trigger a specific action on your dashboard to monitor and manage data completeness effectively.

Scenario Details

  • Dashboard Name Offer Switch Dashboard
  • Widget Name New Offer Switches
  • Measure Name Customers (quantifying the number of customers)
  • Dimension Name Discount Types (categorizing customers based on their payment behavior)
  • Dimension Value “Big Sales” (representing customers who switched )

Objective

Your objective is to count the number of non-blank entries in the ‘Customers’ column and determine if this count is equal to 20. If this condition is met, you want to trigger a particular action on your dashboard. You can use the COUNTNOBLANK function as

COUNTNOBLANK('New Offer Switches'[Customers])=20

COUNTNOBLANK in Calculated Columns

Parameters

ExpressionA placeholder in a function that is replaced with the column names.
Column NameThe name of the column in the dataset or Datasource that contains the values you want to analyze.

Steps to use COUNTNOBLANK in Calculated Columns

  1. Write the COUNTNOBLANK function. For instance COUNTNOBLANK(<expression>)
  2. Replace <expression> with [Column Name] Replace Column Name with the actual name of your column required.
  3. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.