CALCULATE function introduction in Power BI - Dashboard Guide

Dashboard Mode - CALCULATE function introduction

Business Question

How can we find total sales for a specific product category using a flexible formula?

Sample Data

OrderID	ProductCategory	SalesAmount	Region
1001	Electronics	200	East
1002	Clothing	150	West
1003	Electronics	300	East
1004	Furniture	400	South
1005	Clothing	100	West
1006	Electronics	250	North

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[SalesAmount])
  Result: 1400
• KPI Card: Electronics Sales
  Formula: Electronics Sales = CALCULATE(SUM(Sales[SalesAmount]), Sales[ProductCategory] = "Electronics")
  Result: 750
• Bar Chart: Sales by Product Category
  Shows total sales for each category: Electronics (750), Clothing (250), Furniture (400)
• Table: Sales Details
  Shows all rows from sample data for detailed view

Dashboard Layout

+-------------------+-------------------+
|   Total Sales     | Electronics Sales |
|      (KPI)        |      (KPI)        |
+-------------------+-------------------+
|      Bar Chart: Sales by Category      |
|                                       |
+---------------------------------------+
|           Table: Sales Details         |
|                                       |
+---------------------------------------+

Interactivity

A slicer for ProductCategory lets you filter the whole dashboard. Selecting a category updates the KPI cards, bar chart, and table to show only that category's sales.

Self Check

If you add a filter for ProductCategory = Clothing, which components update and what is the new Electronics Sales KPI value?

Answer: The KPI cards, bar chart, and table update. The Electronics Sales KPI shows 0 because no Electronics sales remain after filtering for Clothing.

Key Result

Dashboard shows total sales and filtered sales by product category using CALCULATE function.