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
SUM Power BI DAX exercises.
These concepts all use SUM. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
9Related concepts
Concepts Using SUM
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.
Calculating Quarter-to-Date (QTD) and Previous Quarter Sales
Learn to calculate Quarter-to-Date (QTD) sales and sales for the immediately preceding quarter using Power BI's time intelligence functions.
Calculating Ratios with CALCULATE and ALL in Premier League Data
Learn to calculate different types of ratios and proportions by dynamically modifying filter contexts using the CALCULATE and ALL DAX functions, applying these concepts to Premier League results data.
Calculating Win Ratio Using DAX Variables with Error Handling
Learn to calculate a ratio using DAX variables to improve readability and maintainability, while also implementing robust error handling for divide-by-zero scenarios.
Create Basic DAX Measures for Music Tour Statistics
Learn to create fundamental DAX measures using COUNTROWS and SUM, and apply basic arithmetic operations to calculate key statistics from different tables.
DAX Exercise: Calculate Sales Ratio for Multi-Legged Animals using Variables and CALCULATE
Create a DAX measure using variables and CALCULATE to determine the ratio of sales for the current filter context to the sales of 4-legged and 6-legged animals combined within that same context, handling potential division by zero.
Mastering Advanced Time Intelligence Measures in DAX
Create three complex DAX time intelligence measures: a quarter-over-quarter percentage, a year-to-date percentage against the previous full year, and a three-month moving average of monthly totals.
Optimizing DAX Formulas with Variables: Calculating Corrected Unsold Ticket Percentage
Learn to use DAX variables to break down complex calculations into logical, readable steps, specifically for calculating a corrected percentage of unsold tickets per artist.