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
- Previous: Share of the league’s goals
- Next: Home points that respect the rows
- DAX CALCULATE function
- DAX REMOVEFILTERS function
- Time Intelligence: Same period last year
- Time Intelligence: Previous month
- Time Intelligence: Year-to-date with CALCULATE
- Time Intelligence: Quarter-to-date with CALCULATE
- All Power BI practice exercises