This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	DAX (59 exercises)
Topic ==>	The CALCULATE function (16 exercises)
Level ==>	Average difficulty
Subject ==>	Power BI training

Use the KEEPFILTERS function in DAX to modify the way context filters behave in Power BI Visuals.

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Open the Music Tours - Calculate Keep Filters.pbix file in the folder shown above. On Page 1 you should see a bar chart displaying the average peak chart position for albums by different artists.

A Power BI bar chart displaying a basic DAX measure.

The chart currently shows all artists.

Create a measure which shows the average peak chart position for any three artists of your choice. Replace the current measure in the chart with your new measure.

A DAX measure displayed in a Power BI Desktop bar chart.

Your selection can be as eclectic as you like - we selected names that are short and easy to spell!

Create another measure which shows the average peak chart position and which excludes any three artists of your choice. Create a new bar chart to display this measure along with the Artist field.

A filtered bar chart in Power BI Desktop displaying a DAX measure

This chart appears to lack direction.

On Page 2 of the report you will find a line chart showing the percentage of cancelled shows per year.

A line chart showing the results of a DAX measure in Power BI Desktop

The chart contains a single series.

We'd like to divide the line on the chart into three sections based on the [Show date].[Year] column:

Section	Years to include
Pre-COVID	Up to and including 2020 .
During COVID	2020 to 2022 inclusive.
Post-COVID	2022 or later.

Create three measures to show these values and place them in the line chart (you can remove the original measure when you do this). Apply formatting to the lines for the three series so that your chart resembles the one shown below: