Analyze Brexit Vote Data with Basic DAX Measures
Learn to create simple DAX measures using SUM and DIVIDE for calculating vote proportions, and SUMX for summing expressions over a table to find vote differences.
DAX Function
SUMX Power BI DAX exercises.
These concepts all use SUMX. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
7Related concepts
Concepts Using SUMX
Applying and Overriding Context Transition in Calculated Columns
Learn to create calculated columns that leverage implicit context transition for row-specific calculations and columns that override context to calculate global totals.
Calculating Building Statistics with Basic DAX Measures
Learn to write fundamental DAX measures using aggregation functions like SUM, AVERAGE, MAX, MIN, and iterator functions like SUMX and AVERAGEX, to calculate various statistics.
Context Transition with CALCULATE: Overriding Filters for Comparative Analysis
Learn to use the CALCULATE function to override existing filter contexts, enabling comparative analysis of metrics against a fixed baseline (e.g., comparing country-specific values to a national standard).
Controlling Filter Context with CALCULATE and KEEPFILTERS in DAX
Learn how to use CALCULATE and KEEPFILTERS to precisely control filter context within measures, ensuring calculations apply to specific data subsets while respecting or overriding existing filters.
Filtering Data with Multiple Criteria using DAX
Learn how to use the FILTER function with multiple criteria (AND operator) to selectively sum data in Power BI, building on basic SUMX measures.
Filtering Tables with the DAX FILTER Function for Dynamic Calculations
Understand and apply the DAX FILTER function to create filtered tables for other functions, enabling dynamic calculations based on specific conditions.