IT Professional Curricula     Enterprise Database Systems Solution Area     Data Visualization     Design Data Models in Power BI

---

The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI.
Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context.
Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions.
When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.

---

---

Objectives

PL-300: Working with Filters in Power BI discover the key concepts covered in this course use a common column to set a relationship between tables loaded into Power BI perform an aggregation using a key from one table and values from another related table define a table using the contents of another table by setting a filter context perform operations on a subset of data by defining a filter context set up a DAX function to ignore a filter context for a specific calculation use the ALL function to access all rows in a table by ignoring the filter context apply the ALLSELECTED function to ignore the context set by a visualization employ DAX functions to ignore the query context set by Power BI visualizations summarize the key concepts covered in this course