PL-300: Working with Filters in Power BI

Microsoft Power BI    |    Intermediate
  • 10 videos | 1h 22m 1s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 115 users Rating 4.4 of 115 users (115)
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 PL-300: 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

  • 3m 24s
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course PL-300: Maps, Waterfall Charts, & Scatter Plots in Power BI
Rating 4.5 of 83 users Rating 4.5 of 83 users (83)
Book A Power BI Compendium: Answers to 65 Commonly Asked Questions on Power BI
Course Getting Started with Power Query in Power BI
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting Started with Design Thinking
Rating 4.4 of 2479 users Rating 4.4 of 2479 users (2479)
Course PL-300: Power BI for Data Analysis
Rating 4.5 of 1379 users Rating 4.5 of 1379 users (1379)
Course PL-300: Loading & Transforming Data in Power BI
Rating 4.7 of 830 users Rating 4.7 of 830 users (830)