COUNT and DISTINCTCOUNT in Power BI - Dashboard Guide

Dashboard Mode - COUNT and DISTINCTCOUNT

Business Question

How many total sales transactions are there, and how many unique customers made purchases?

Sample Data

TransactionID	CustomerID	Product	Amount
1001	C001	Notebook	15
1002	C002	Pen	5
1003	C001	Backpack	45
1004	C003	Pen	5
1005	C004	Notebook	15
1006	C002	Backpack	45
1007	C005	Pen	5

Dashboard Components

KPI Card: Total Transactions

Shows the total number of sales transactions.

DAX formula: Total Transactions = COUNT(Sales[TransactionID])

Result: 7

KPI Card: Unique Customers

Shows the number of distinct customers who made purchases.

DAX formula: Unique Customers = DISTINCTCOUNT(Sales[CustomerID])

Result: 5

Table: Sales Details

Displays all sales transactions with details.

Dashboard Layout

+----------------------+---------------------+
| Total Transactions    | Unique Customers    |
|       [ 7 ]          |       [ 5 ]         |
+----------------------+---------------------+
|                                          |
|           Sales Details Table             |
|                                          |
+------------------------------------------+
    

Interactivity

Adding a slicer to filter by Product will update both KPI cards and the sales details table to show data only for the selected product(s).

For example, selecting "Pen" will update:

• Total Transactions to 3 (transactions 1002, 1004, 1007)
• Unique Customers to 3 (customers C002, C003, C005)
• Sales Details Table to show only those 3 transactions

Self Check

If you add a filter for CustomerID = C001, which components update and what are their new values?

• Total Transactions updates to 2 (transactions 1001, 1003)
• Unique Customers updates to 1 (customer C001)
• Sales Details Table shows only transactions 1001 and 1003

Key Result

Dashboard showing total sales transactions and unique customers with product filter interactivity.