Sales by category and year

In previous exercises, you've calculated revenue by using a SUM() function to total the LinePrice column. Now you'll need to calculate the total sales and filter by category Bikes and order year 2018.

In this exercise, we will be utilizing the CALCULATE() function. You can read up on this function in Microsoft Documentation.

If you lost progress, close any open reports and load 2_3_calculate.pbix from the Exercises folder.

This exercise is part of the course

Introduction to DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise