# Introduction to the Distinct Count Check

Source: https://userguide.qualytics.io/data-quality-checks/distinct-count/introduction/

*Requires the Data Quality (DQ) module.*

The Distinct Count check asserts that the number of distinct values in a field satisfies a comparison against an expected number. Use it when the cardinality of a column is itself the rule: a lookup table with a known number of entries, a dimension that should not gain categories overnight.

This section is the complete guide to the check. The Deep Dive covers the definition, properties, and full evaluation semantics, explains how anomalies are reported, walks through production examples, and collects best practices; the How-tos are step-by-step tutorials for creating, editing, and deleting a check; the API page documents the payload for programmatic use; and the FAQ answers the most frequent questions.

## Next Steps

- **How It Works**

  The complete reference: definition, field scope, the comparison operators, approximation, NULL handling, filter behavior, and why coverage does not apply.

  [How It Works](https://userguide.qualytics.io/data-quality-checks/distinct-count/deep-dive/how-it-works/)
- **Anomaly Reporting**

  The anomaly message the check produces, what the counts mean, and why per-row reporting does not apply.

  [Anomaly Reporting](https://userguide.qualytics.io/data-quality-checks/distinct-count/deep-dive/anomaly-reporting/)
- **Examples**

  Three production scenarios with sample data, anomaly messages, and the SQL equivalent of what the check evaluates.

  [Examples](https://userguide.qualytics.io/data-quality-checks/distinct-count/deep-dive/examples/)
- **Best Practices**

  Guidelines for choosing the operator, allowing for approximation, and keeping the signal clean.

  [Best Practices](https://userguide.qualytics.io/data-quality-checks/distinct-count/deep-dive/best-practices/)
- **Permissions**

  The team permission each action needs: view, create, edit, archive, restore, and delete.

  [Permissions](https://userguide.qualytics.io/data-quality-checks/distinct-count/deep-dive/permissions/)
- **Create a Check**

  Step-by-step tutorial for creating a Distinct Count check with a comparison and a value.

  [Create a Check](https://userguide.qualytics.io/data-quality-checks/distinct-count/how-tos/create-a-check/)
- **Edit a Check**

  Step-by-step tutorial for changing the operator or the expected count, or adjusting the filter.

  [Edit a Check](https://userguide.qualytics.io/data-quality-checks/distinct-count/how-tos/edit-a-check/)
- **Delete a Check**

  Step-by-step tutorial for archiving a check and deleting it permanently.

  [Delete a Check](https://userguide.qualytics.io/data-quality-checks/distinct-count/how-tos/delete-a-check/)
- **Troubleshooting**

  Common problems with approximation, NULLs, operator choice, and anomaly reporting, and how to resolve them.

  [Troubleshooting](https://userguide.qualytics.io/data-quality-checks/distinct-count/troubleshooting/)
- **API**

  Payload shape and field notes for creating a Distinct Count check programmatically.

  [API](https://userguide.qualytics.io/data-quality-checks/distinct-count/api/)
- **FAQ**

  Short answers to questions about approximation, operators, NULLs, and anomaly reporting.

  [FAQ](https://userguide.qualytics.io/data-quality-checks/distinct-count/faq/)

*Last updated: October 19, 2026.*
