Power BI Data Model Design: Working with Filters

Microsoft Power BI 2.96    |    Intermediate
  • 10 Videos | 1h 22m 1s
  • Includes Assessment
  • Earns a Badge
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    3m 24s
    UP NEXT
  • Playable
    2. 
    Defining Relationships between Tables
    12m 51s
  • Locked
    3. 
    Building DAX Formulas Spanning Tables
    11m 25s
  • Locked
    4. 
    Working with a Calculated Table
    5m 5s
  • Locked
    5. 
    Working in a Filter Context
    9m 56s
  • Locked
    6. 
    Ignoring the Filter Context
    10m 42s
  • Locked
    7. 
    Ignoring Filters with ALL
    10m 33s
  • Locked
    8. 
    Applying the ALLSELECTED Function
    10m 5s
  • Locked
    9. 
    Using ALLEXCEPT and REMOVEFILTERS
    5m 11s
  • Locked
    10. 
    Course Summary
    2m 49s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.