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: An Overview of Data Modeling in Power BI
Rating 4.6 of 227 users Rating 4.6 of 227 users (227)
Course PL-300: Analysis & Sharing Features in Power BI
Rating 4.6 of 137 users Rating 4.6 of 137 users (137)
Course Data Loading & Visualization in Power BI: Getting Started
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Extracting Insights from Data Using Power BI
Rating 4.7 of 98 users Rating 4.7 of 98 users (98)
Course Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Rating 4.6 of 1028 users Rating 4.6 of 1028 users (1028)
Course PL-300: Analysis & Sharing Features in Power BI
Rating 4.6 of 137 users Rating 4.6 of 137 users (137)