Get startedGet started for free

Calculating with a filter

When performing analysis for business decisions it's important to analyze data from different perspectives to find trends/issues. In this example, World Wide Importers recently introduced items that required refrigeration (i.e. chilled items). You're asked to look into this further to see if any trends exist among salespersons in the sale of these items. You'll do that by looking at what percent of chiller item sales are part of total sales for a salesperson.

If you have lost any progress, close any open reports and load 3_2_filter.pbix from the Exercises folder on the desktop.

This exercise is part of the course

DAX Functions in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise