This page has 0 threads | Add post

Exercises

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

Software ==>	DAX (59 exercises)
Topic ==>	Variables (3 exercises)
Level ==>	Relatively easy
Subject ==>	Power BI training

Use variables a DAX measures to break a long formula into separate steps.

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 - Variables.pbix file in the folder shown above. You'll find a matrix showing a count of buildings for each country and city.

A matrix visual in Power BI Desktop showing the results of a DAX measure.

A sample of values in the matrix.

Create a new measure called Count of Buildings % of Country and declare a variable to store the count of buildings. Here's some sample code to help you:

A DAX variable in a measure in Power BI Desktop

You can make up a better name for your variable. Replace the word Expression with code which counts the rows of the Building table.

In the same measure, declare another variable which counts the number of buildings and removes the filter applied by the City field.

You can use the CALCULATE and REMOVEFILTERS functions to do this.

In the same measure, add a RETURN statement which returns the result of dividing the first variable by the second variable. Apply some formatting and display the measure in the matrix.