COUNTX function calculates a value for each row in the table, and then counts the number of calculated values that are not blank.
expression argument can be of any type.
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))