DAX Function
These concepts all use CALCULATE. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
Understand and apply the DAX FILTER function to create virtual tables and modify filter context dynamically within measures, enabling complex aggregations based on related table conditions.
Learn to create calculated columns that leverage implicit context transition for row-specific calculations and columns that override context to calculate global totals.
Create robust measures using CALCULATE to apply various filters and calculate conditional aggregations, such as percentages based on venue status, show cancellations, and ticket sales.
To calculate the required number of comfort breaks for each film based on its running time, by referencing a non-joined comfort breaks table using the EARLIER function to manage row context.
Learn to apply DAX date intelligence functions like TOTALYTD, DATESYTD, and PARALLELPERIOD in conjunction with CALCULATE to perform time-based calculations and derive insightful ratios.
Learn how to use the ALLEXCEPT function in DAX to dynamically remove all filters from a table except for specified columns, enabling calculations like percentage of year total within a filtered context.
Learn to calculate Quarter-to-Date (QTD) sales and sales for the immediately preceding quarter using Power BI's time intelligence functions.
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.
Learn to create DAX measures that conditionally omit specific data categories (like environments) from calculations in a matrix visual, leveraging the CALCULATE, VALUES, and FILTER functions to manipulate filter context.
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).
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.
Learn to use the CALCULATE function in DAX to apply single and multiple filters to measures, including combining filter conditions with logical OR (||).
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.
To learn how to use the USERELATIONSHIP function to activate inactive relationships in DAX, allowing for flexible date-based calculations on a single date dimension.
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.
Understand and apply the CALCULATE function to modify filter context within DAX measures, enabling calculations based on specific filter conditions.
Learn to effectively use the REMOVEFILTERS function within CALCULATE to modify or completely clear filter context for measures, enabling robust comparative analysis and consistent visual displays in Power BI.
Understand and apply the CALCULATE function to modify and remove filter contexts using ALL, thereby calculating contributions relative to different total scopes.
Understand and apply the REMOVEFILTERS function within CALCULATE to manipulate filter context, enabling calculations that ignore specific filters or all filters.
Understand and apply the ALLSELECTED function to calculate percentages within a visual, ignoring internal visual filters but respecting external slicers.
Understand and apply the KEEPFILTERS function within CALCULATE to precisely control filter context for inclusion and exclusion scenarios, and to define conditional logic in Power BI visuals.
Learn to leverage Power BI's automatic date tables to create robust time intelligence measures using DAX functions like TOTALMTD, SAMEPERIODLASTYEAR, DATEADD, and ISINSCOPE for calculating running totals and period-over-period comparisons.
Understand and apply the DAX CALCULATE function to modify or replace existing filter contexts within Power BI visuals, using various filter conditions including logical operators and string functions.
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.
Learn to use DAX variables to break down complex formulas into logical, readable steps, improving both maintainability and understanding of measures.
Learn how to use a disconnected slicer to dynamically influence measure calculations without directly filtering the main data model, and how to apply this to visual titles and conditional formatting.