COUNTX

Description

The COUNTX function calculates a value for each row in the table, and then counts the number of calculated values that are not blank.

Usage

COUNTX(TABLE_EXPR, EXPRESSION)

The expression argument can be of any type.

Example

You can use the COUNTX function in a pivot table to count the number of beneficiaries who provided a phone number:

COUNTX([Beneficiary Registry], PHONE_NUMBER)

The second argument can be expression in a row context, for example if we wanted to count the number of beneficiaries who provided a fixed line number or a mobile number, we could use the COALESCE function:

COUNTX([Beneficiary Registry], COALESCE(FIXED_LINE_NUMBER, MOBILE_NUMBER))
Next item
GREATER OR EQUAL (>=)