Applying Filters to Measures Using CALCULATE in DAX
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.
DAX Function
ISBLANK Power BI DAX exercises.
These concepts all use ISBLANK. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
5Related concepts
Concepts Using ISBLANK
Conditional Logic in Calculated Columns: IF, SWITCH, ISBLANK, AND
Learn to apply conditional DAX functions such as IF, SWITCH, ISBLANK, AND, and OR to create descriptive calculated columns, enhancing data categorization and reporting in Power BI.
Implementing Conditional Logic with IF and SWITCH for Calculated Columns in Power BI
Create calculated columns in Power BI with DAX conditional logic, then verify the result in report visuals.
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.
Retrieving Related Data with DAX's RELATED Function
Learn how to use the RELATED DAX function to retrieve values from a related table into a calculated column, and effectively handle cases where no related value is found using ISBLANK.