Microsoft · PL-300
Measures and CALCULATE
PL-300 · Lesson 6 of 15 · 39:10
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the PL-300 exam (Microsoft Certified: Power BI Data Analyst Associate). In this lesson: implicit and explicit measures, SUM, COUNTROWS, and DISTINCTCOUNT, calculated columns and tables, CALCULATE with filters and modifiers like REMOVEFILTERS, and quick measures. Includes three original practice questions.
Preview the topics
- Each order has several order lines, and the Sales table stores one row per line, with an OrderID column. A measure must count orders, not lines. Which function fits?
- Authors need a Ship Date table, to filter sales by ship date in the same visual as the order date. The Date table already exists. What should the modeler create?
- A matrix shows Total Sales by region. A new measure must show the sales of all regions on every row, so that each region’s share can be computed. Which measure fits?