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 ==>	Relatively easy
Subject ==>	Power BI training

Use the REMOVEFILTERS function in DAX to modify the filter context of measures in Power BI Desktop

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 Tallest Buildings - Calculate Remove Filters.pbix file in the folder shown above. You'll find a gauge and a table showing the average height of buildings.

A gauge and table visual displaying DAX measures in Power BI Desktop.

The maximum value of the gauge is set using a measure called Max height.

When you select a country in the table, the average height on the gauge changes. Unfortunately, so does the maximum value.

DAX measures displayed in gauge and table visuals in Power BI Desktop.

The gauge looks a bit odd when you select certain countries.

Create a new measure called Max height no filters which calculates the maximum height of buildings and removes all filters. Assign this new measure to the Maximum value bucket of the gauge visual (this will replace the existing measure in this bucket).

Power BI Desktop gauge and table visuals displaying DAX measures.

The maximum value of the gauge no longer changes when you select different countries.

Create a new measure called Avg height all countries which calculates the average height of buildings, removing any filter applied by the Country[Country] field. Add this measure to the table visual to check the result.

DAX measures displayed in a table visual in Power BI Desktop.

Each row should show the same value.

Add a new measure called Avg height compared to all countries which subtracts Avg height all countries from Avg height. Display this measure in the table and apply some conditional formatting to make the results easier to read.