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))