Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Quick Measures and KPI

Quick measures and Key Performance Indicators (KPIs) help users calculate and monitor important business metrics in Power BI. Quick measures provide predefined calculation templates, while KPIs compare actual performance against a target or goal.

In this lesson, you will learn how to create quick measures, build KPI calculations with DAX, compare actual results with targets, and present business performance clearly in report visuals.

Learning Objectives

  • Understand quick measures and their purpose.
  • Create a quick measure using the Power BI interface.
  • Understand KPIs and performance targets.
  • Calculate target achievement and variance using DAX.
  • Display KPI information using Card, KPI, and gauge visuals.
  • Choose suitable formats for business performance reporting.

1. What Are Quick Measures?

Quick measures are predefined calculations that Power BI builds through a guided interface. They generate DAX formulas for common business calculations without requiring you to write the entire formula manually.

Depending on the data model and available options, quick measures can include:

  • Running totals.
  • Year-to-date and period comparisons.
  • Differences from another value.
  • Percentage differences.
  • Mathematical operations and category-based calculations.
Quick Measure Workflow Choose Calculation Quick measure menu Select Fields Values and parameters Generated DAX Review and use Quick measures generate formulas that you can inspect and learn from.

2. How to Create a Quick Measure

  1. Open your report in Power BI Desktop.
  2. In the Data or Fields pane, select the table where you want the measure.
  3. Right-click the table or use the available modeling options.
  4. Select New quick measure.
  5. Choose a calculation from the available calculation types.
  6. Provide the required base measure, field, or other parameters.
  7. Review the calculation and select OK.
  8. Inspect the generated DAX formula and test the result in a visual.
Learning Tip: Quick measures are useful for learning DAX. Inspect the generated formula to understand which functions Power BI uses, then practise writing similar calculations yourself.

3. What Is a KPI?

A Key Performance Indicator is a measurable value used to track progress toward a business objective. A KPI usually compares an actual result with a target and helps users identify whether performance is on track.

Common examples include:

  • Actual sales compared with a sales target.
  • Profit compared with a profit goal.
  • Orders completed compared with the required order count.
  • Customer satisfaction compared with a desired score.
  • Monthly revenue compared with a budget.
KPI Performance Comparison Actual Sales 900,000 Current performance vs. Sales Target 1,000,000 Expected performance Achievement = Actual Sales ÷ Sales Target = 90%

4. Create Base Measures for a KPI

Before creating a KPI, create measures for the actual business result and its target. The following examples assume a Sales table with a numeric SalesAmount column and a separate target table named SalesTargets.

Total Sales =
SUM(Sales[SalesAmount])

If the target table contains one target value per reporting period, create the target measure using the correct aggregation for your model.

Sales Target =
SUM(SalesTargets[TargetAmount])
Important: The target calculation depends on your data model. Make sure the target table has the correct granularity and relationships. If a target is repeated across transaction rows, summing it may produce an incorrect result.

5. Calculate Target Achievement

Target achievement expresses actual performance as a percentage of the target. DIVIDE safely handles a zero or blank denominator.

Target Achievement % =
DIVIDE(
    [Total Sales],
    [Sales Target],
    0
)

Format the measure as Percentage. If actual sales are 900,000 and the target is 1,000,000, target achievement is 90%.

6. Calculate Variance Against Target

Variance shows the numerical difference between actual performance and the target.

Sales Variance =
[Total Sales] - [Sales Target]

A positive variance means actual sales are above the target. A negative variance means actual sales are below the target.

Sales Variance % =
DIVIDE(
    [Sales Variance],
    [Sales Target],
    0
)
Actual Sales Target Variance Achievement
1,100,000 1,000,000 +100,000 110%
1,000,000 1,000,000 0 100%
900,000 1,000,000 -100,000 90%

7. Create a KPI Status Measure

A status measure can classify performance according to business rules. The thresholds below are examples; adjust them to match your organization's actual KPI policy.

Sales KPI Status =
SWITCH(
    TRUE(),
    [Target Achievement %] >= 1, "Target Achieved",
    [Target Achievement %] >= 0.9, "Near Target",
    "Below Target"
)

This measure returns Target Achieved at 100% or above, Near Target from 90% to below 100%, and Below Target when achievement is below 90%.

Best Practice: Define KPI thresholds with business stakeholders. A target that works for sales may not be suitable for customer service, manufacturing, or financial reporting.

8. KPI Visuals in Power BI

Visual Purpose Useful Fields
Card Displays one key result clearly. Total Sales or Target Achievement %.
KPI visual Compares an indicator with a target over a trend axis. Indicator, trend axis, and target goal.
Gauge Shows progress toward a target within a defined range. Value, minimum, maximum, and target value.
Clustered column chart Compares actual values across categories. Category and Total Sales.
Table Shows actual values, targets, variance, and status together. Period, actual, target, variance, and achievement.
KPI Dashboard Layout Total Sales 900K Target Achievement 90% Sales Variance -100K Monthly Performance

9. Configure the KPI Visual

  1. Create a measure for actual performance, such as Total Sales.
  2. Create a measure for the target, such as Sales Target.
  3. Add a KPI visual to the report canvas.
  4. Assign the actual measure to the Indicator field.
  5. Assign a suitable date field to the Trend axis.
  6. Assign the target measure to the Target goals field, where available.
  7. Review the trend and verify the displayed result.
Important: The built-in KPI visual requires an appropriate trend axis, typically a date field. For a simple comparison between an actual value and a target, a Card or Gauge visual may be more suitable.

10. Format KPI Reports

  • Use currency formatting for sales and profit values.
  • Use percentage formatting for achievement and variance percentages.
  • Use clear titles that identify the metric and reporting period.
  • Keep target definitions consistent across report pages.
  • Use conditional formatting only when colors have a clear meaning.
  • Provide enough context to explain whether a KPI is above or below target.

11. Common Mistakes

Problem Possible Cause Solution
Target achievement shows an incorrect percentage. Target aggregation or formatting is incorrect. Verify the target measure and percentage format.
Target values appear too high. A target is repeated across transaction rows and summed. Check target table granularity and model relationships.
KPI trend is missing. No suitable date field is assigned to the trend axis. Add an appropriate date field and verify its relationship.
Status labels are misleading. Thresholds do not match business rules. Agree on the thresholds and test boundary values.
Quick measure result is unexpected. Incorrect fields or calculation parameters were selected. Inspect the generated DAX and validate the result.

12. Student Practice Tasks

Task 1: Create a quick measure using one of the available predefined calculations.

Task 2: Inspect the generated DAX formula and explain its purpose.

Task 3: Create Total Sales and Sales Target measures.

Task 4: Calculate Target Achievement % using DIVIDE.

Task 5: Calculate Sales Variance and Sales Variance %.

Task 6: Create a KPI status measure using SWITCH(TRUE()).

Task 7: Display the measures in Card, Table, and Gauge visuals.

Task 8: Create a KPI visual with a date trend axis and a target goal.

13. Knowledge Check

Question 1: What is a quick measure?

Answer: A predefined calculation that Power BI builds through a guided interface.

Question 2: What does a KPI compare?

Answer: A performance indicator against a target or goal, often across time.

Question 3: Which function can calculate target achievement safely?

Answer: DIVIDE().

Question 4: What does a negative sales variance mean?

Answer: Actual sales are below the target.

Question 5: What is commonly required for a built-in KPI visual's trend?

Answer: A suitable trend-axis field, typically a date field.

Summary

In this lesson, you learned how quick measures generate predefined DAX calculations and how KPIs compare actual performance against business targets. You created measures for Total Sales, Sales Target, Target Achievement, Sales Variance, and KPI Status.

You also explored Card, KPI, Gauge, and Table visuals for presenting performance results. Always verify target aggregation, reporting periods, model relationships, and KPI thresholds before using performance indicators to support business decisions.