Skip to content
Infoveave Help

COUNTNOBLANKX

The COUNTNOBLANKX function is used to count the number of rows within a specified table or dataset that meet a specific condition. It evaluates each row against the given condition and increments the count when the condition is true. This function is particularly useful for filtering and counting data based on specified criteria.

Return Value

  • The return value of the COUNTNOBLANKX function is an integer representing the count of rows that satisfy the condition within the specified table or dataset.

Remark

  • COUNTNOBLANKX is a useful function when you want to count rows based on specific criteria, such as filtering rows in a dataset that meet certain conditions or constraints.

Syntax

COUNTNOBLANKX(<expression>,<condition>)

COUNTNOBLANKX in Board Expression

Parameters

ExpressionA placeholder in a function that is replaced with the actual widget and measure names.
ConditionA placeholder in a function that is replaced with the condition filter.
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.
DimensionRepresents the dimension column that is being displayed or analyzed using the widget.
Dimension ValueRepresents the specific dimension items within the dimension column used for the visualization in the widget.

Steps to use COUNTNOBLANKX

  1. Write the COUNTNOBLANKX function. For instance COUNTNOBLANKX(<expression>,<condition>)
  2. Where expression equals 'Widget Name'[Measure] and condition equals [Dimension Name]="Dimension Value".Replace Widget Name with the actual name of your widget, Measure with the required measure name, Dimension with the required dimension name and Dimension Value with the dimension value of the selected dimension name.
  3. Set the COUNTNOBLANKX function based on the scenario.
  4. To learn how to configure an Expression in Infoveave, visit the section Configure Expression.

Example

Scenario You’re managing a dynamic dataset and an associated Infoboard named ‘Finance Analytics’ within your Financial Analytics System. Your mission is to count the number of rows where customers simultaneously qualify for two distinct discount categories- “Early Payment” and “No Discount.” This is a crucial activity for cost analysis and customer segmentation.

Scenario Details

  • Dashboard Name Finance Analytics Dashboard
  • Widget Name Finance Data Overview
  • Measure Name Total Customers (representing the number of customers)
  • Dimension Name Discount Types (categorizing customers based on their payment behavior)
  • Dimension Values “Early Payment” (customers who pay their bills early) and “No Discount” (customers not eligible for any discount)

Objective Your objective is to count the number of rows where customers fall into specific discount categories, such as “Early Payment” and “No Discount,” 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 COUNTNOBLANKX function like this

COUNTNOBLANKX('Finance Data Overview'[Total Customers], [Discount Types] = "Early Payment" AND [Discount Types] ="No Discount") = 20

COUNTNOBLANKX in Calculated Columns

Parameters

ExpressionA placeholder in a function that is replaced with the column name.
ConditionA placeholder in a function that is replaced with the condition filter.
Column NameThe name of the column in the dataset or Datasource that contains the values you want to analyze.
Filter ConditionA filter condition returns the data points that meet the defined condition that you want to analyze. The filter condition can be either a string or a numeric.

Steps to use COUNTNOBLANKX in Calculated Columns

  1. Write the COUNTNOBLANKX function. For instance COUNTNOBLANKX(<expression>,<condition>)
  2. Replace <expression> with required [Column Name] and <condition> equals [Column Name]="Filter Condition"
  3. Replace Column Name with the actual name of your column and Filter Condition with the required condition to be applied on the columns.
  4. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Objective Consider that you have the below sales dataset, your goal is to identify the rows in the dataset where ORDER PRIORITY is Low and [DEALER]= Hirthe and Sons, then they should be eligible for a discount.

SHIP DATEORDER PRIORITYDEALERPACKET IDSHIPPING QUANTITYINVOICE PRICELOCATION
05-05-2024LowHirthe and Sons10048328.65875KL
10-05-2024LowHirthe and Sons10063136.89025TN
15-05-2024MediumSipes Group10069328.65875TN
20-05-2024HighSipes Group10063525.553KL
25-05-2024HighMiller Inc10089525.553TK
  • You can use the COUNTNOBLANKX function like
COUNTNOBLANKX([DEALER],[ORDER PRIORITY]="Low" AND [DEALER]="Hirthe and Sons")

The new calculated column will return the value as 2.

SHIP DATEORDER PRIORITYDEALERPACKET IDSHIPPING QUANTITYINVOICE PRICELOCATIONEligible
05-05-2024LowHirthe and Sons10048328.65875KL2
10-05-2024LowHirthe and Sons10063136.89025TN2
15-05-2024MediumSipes Group10069328.65875TN2
20-05-2024HighSipes Group10063525.553KL2
25-05-2024HighMiller Inc10089525.553TK2