Data basics

Distinct count

  • Data basics

Definition

Counting each unique value only once, such as counting customers rather than orders.

For your role

Choose your role to see what this term means in your work.

Why it matters

Using a normal count instead can overstate numbers like customers or users.

Where it is used

Power BI measures, SQL queries and dashboards.