Power BI Exercises

Points across both seasons

CALCULATE & Filter Context · Advanced · Chapter 8 of 10. The most important function in DAX, step by step.

The request, from Rhys Abara, Analyst, Northfield League: "In the season matrix I also want each team's two-season total, on every row." A measure named Points All Seasons.

REMOVEFILTERS(column) removes the filter on one column only. With Season on the rows, CALCULATE([Total Points], REMOVEFILTERS(Results[Season])) shows each team’s points over both seasons on every season’s row.

Task: Create Points All Seasons = CALCULATE([Total Points], REMOVEFILTERS(Results[Season])).

Practice data: Northfield League, a fictional football league with clubs, matches and goals. The model has the Results and Team tables.

DAX functions used: CALCULATE, REMOVEFILTERS.

How it works: the exercise opens a practice copy of the Power BI report editor in your browser. Do the task, press Check, and your result is compared with the expected answer in seconds. Hints are there if you get stuck.

Keep practicing