VALUES and DISTINCT in Power BI - Dashboard Guide

Dashboard Mode - VALUES and DISTINCT

Business Question

Which unique product categories and their sales amounts are in our sales data? We want to see distinct categories and total sales per category.

Sample Data

OrderID	ProductCategory	SalesAmount
1001	Electronics	200
1002	Furniture	450
1003	Electronics	300
1004	Clothing	150
1005	Furniture	200
1006	Clothing	100

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[SalesAmount])
  Result: 1400
• Table Visual 1: Distinct Product Categories
  Formula: Distinct Categories = DISTINCT(Sales[ProductCategory])
  Shows unique categories: Electronics, Furniture, Clothing
• Table Visual 2: Product Categories with Total Sales
  Formula: Total Sales by Category = SUM(Sales[SalesAmount]) grouped by ProductCategory
  Results:
  - Electronics: 500
  - Furniture: 650
  - Clothing: 250
• Table Visual 3: VALUES function output
  Formula: VALUES(Sales[ProductCategory])
  Shows unique categories same as DISTINCT

Dashboard Layout

+----------------------+---------------------------+
|      Total Sales      |   Distinct Categories      |
|       (KPI Card)      |       (Table Visual 1)     |
+----------------------+---------------------------+
|       Sales by Category Table (Table Visual 2)       |
+-----------------------------------------------------+
|       VALUES Output Table (Table Visual 3)           |
+-----------------------------------------------------+

Interactivity

Applying a slicer filter on ProductCategory updates all tables and the KPI card to show data only for the selected categories. For example, selecting 'Electronics' filters the sales and recalculates totals accordingly.

Self Check

If you add a filter to show only Furniture category, which components update and what results do they show?

• Total Sales KPI: Updates to 650
• Distinct Categories Table: Shows only 'Furniture'
• Sales by Category Table: Shows 'Furniture' with 650 sales
• VALUES Output Table: Shows only 'Furniture'

Key Result

Dashboard showing unique product categories and their total sales using VALUES and DISTINCT functions.