How to create simple measures in Power BI

Summary of the video (Power BI measures + setup)

• Goal: Learn how to create simple DAX measures in Power BI Desktop to improve how visuals look and behave (especially with filters).

Data import & preparation

• Loads reseller sales data from an Excel spreadsheet.
• Uses Transform Data to improve display quality, including:
  • Renaming column labels (e.g., “Product” → “Name”, “No” → “N/A”)
  • Replacing null values with “NA”
  • Formatting columns:
    • Order Date → Date type
    • Unit Price → Fixed decimal
    • Discount → Percentage
    • Sales Amount and Total → Fixed decimal

Basic visual formatting

• Adds standard visuals (e.g., list/bar/card).
• Demonstrates Format options such as:
  • Axes colors
  • Bar colors
  • Background styling

Creating measures (core tutorial)

1. Total Sales

   • Created as a DAX measure using the SUM of Sales Amount.
   • When added to a Card visual, it displays the total.

2. Average Sales

   • Created using AVERAGE of Sales Amount.
   • Added to another Card to show the average value.

• Shows resizing/repositioning of cards and using color formatting for a consistent dashboard look.

Filter-reactive vs fixed measures

• Creates a third measure called Fixed Total:
  • Uses CALCULATE with:
    • the [Total Sales] measure
    • REMOVEFILTERS so it ignores slicer/filter selections
• Result:
  • The “Total Sales” card changes when a salesperson is selected.
  • The “Fixed Total” card stays the same, always showing the overall total.

Presentation tip

• Mentions using the Format Painter to match styling across visuals (may not be perfect for charts, but helps maintain a consistent look).

Main speakers/sources

• Speaker: Unspecified (taught by a single instructor; no name given in the subtitles)
• Source material: Power BI Desktop (instructional tutorial using DAX measures)