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
CONTAINSSTRING Power BI DAX exercises.
These concepts all use CONTAINSSTRING. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
4Related concepts
Concepts Using CONTAINSSTRING
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 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.
Modifying Filter Context with DAX CALCULATE in Power BI
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.