DISTINCTCOUNT

The DISTINCTCOUNT function in Infoveave calculates the number of unique, distinct values in a column or dataset. It counts how many different items are present without considering duplicates.

Applicable to

• Calculated Columns
• Expressions

Return Value

• The return value of the DISTINCTCOUNT function is an integer representing the count of unique, non-duplicate values in the specified column.

Remark

• DISTINCTCOUNT is useful when you want to know how many distinct items are in a particular column, such as counting the number of unique customers, products, or categories.
• DISTINCTCOUNT function can be used across Date, Strings and Numbers.
• DISTINCTCOUNT function takes all values into account.

Syntax

DISTINCTCOUNT(<expression>)

DISTINCTCOUNT in Board Expression

Note

Expressions help you add visual effects to your dashboard through widget-specific conditions. It is important to note that the Expressions are not meant to manage or modify data.

Parameter	Description
Expression	A placeholder in a function that is replaced with the actual widget and measure names.
Widget Name	The specific name or identifier of the widget being used for data visualization in the specific Infoboard.
Measure	Represents the name of the measure that is being displayed or analyzed using the widget.

Steps to Use DISTINCTCOUNT

1. Write the DISTINCTCOUNT function. For instance DISTINCTCOUNT(<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 DISTINCTCOUNT function based on the scenario. For instance, you can set the count 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 You’re overseeing a dataset and an Infoboard titled ‘Green Solar’ within your Energy Consumption Analysis System. Your goal is to count the number of unique solar customers without counting any customer twice. This is vital for assessing customer engagement and ensuring data accuracy.

Scenario Details

• Dashboard Name Consumption Analysis
• Widget Name Green
• Measure Name Customers (representing the number of customers)

Objective Your objective is to count the number of unique customers without counting any customer twice. If this count equals 100, you want to trigger a specific action on your dashboard.

• You can use the DISTINCTCOUNT function like this

DISTINCTCOUNT('Green'[Customers])=100

DISTINCTCOUNT in Calculated Columns

Parameter	Description
Expression	A placeholder in a function that is replaced with the column names.
Column Name	The name of the column in the dataset or Datasource that contains the values you want to analyze.

Steps to use DISTINCTCOUNT in Calculated Columns

1. Write the DISTINCTCOUNT function. For instance DISTINCTCOUNT(<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.

Objective Consider that you have the below sales dataset, your goal is to count the number of distinct values in the column COUNTRY.

ORDER DATE	COUNTRY	CATEGORY	UNIT PRICE	MARKET PRICE	QUANTITY
2024-01-03	Brazil	Baby Food	38.41	43.7874	2
2024-01-07	Japan	Spices	45.56	50.8155	20
	Japan			43.7874	10
2024-01-18				32.3019	4
2024-01-22	Brazil	Cosmetics	28.335	23.0109	7
2024-01-26	Canada		20.185	23.0109	9
2024-01-04	France	Cereal	25.26	28.7964	9
2024-01-09	Brazil	Cereal	44.575	50.8155	8
2024-01-14	Brazil	Snacks	20.185		4
	Brazil	Cosmetics	40.485	46.1529	2

You can use the DISTINCTCOUNT function like

DISTINCTCOUNT([COUNTRY])

The new calculated column “Total Entries” will return the total number of rows in the dataset considering nulls and blanks as 4.

ORDER DATE	COUNTRY	CATEGORY	UNIT PRICE	MARKET PRICE	QUANTITY	TOTAL ENTRIES
03-01-2024	Brazil	Baby Food	38.41	43.7874	2	4
07-01-2024	Japan	Spices	45.56	50.8155	20	4
	Japan			43.7874	10	4
18-01-2024				32.3019	4	4
22-01-2024	Brazil	Cosmetics	28.335	23.0109	7	4
26-01-2024	Canada		20.185	23.0109	9	4
04-01-2024	France	Cereal	25.26	28.7964	9	4
09-01-2024	Brazil	Cereal	44.575	50.8155	8	4
14-01-2024	Brazil	Snacks	20.185		4	4
	Brazil	Cosmetics	40.485	46.1529	2	4

Note

*The DISTINCTCOUNT function allows you to apply multiple conditions, such as counting the number of distinct values when the COUNTRY is “Brazil” and the CATEGORY is “Baby Food”.

DISTINCTCOUNT([COUNTRY], [COUNTRY]="Brazil", [CATEGORY]="Baby Food")

*You can apply date conditions when using the DISTINCTCOUNT function as below

DISTINCTCOUNT([ORDER DATE], [ORDER DATE]=DATEVALUE("2024-05-05"))