This page has 0 threads | Add post

Exercises

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

Software ==>	Power BI (160 exercises)
Topic ==>	Quick measures (5 exercises)
Level ==>	Average difficulty
Subject ==>	Power BI training

Creating Quick measures in Power BI

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 Power BI file called Movie Data.pbix from the folder above.

Add a table visual with Oscar Wins and Box Office Dollars.

Set the Oscar Wins column to not summarise.

You can stop a column from summarising data by clicking its dropdown in the columns bucket of the field well and choosing the Don't summarize option.

Now we'd like to divide each Sum of Box Office Dollars value by the total. To do this, create two quick measures in the Film table:

Create a quick measure giving the total Sum of Box Office Dollars with filters not applied.

This will be our denominator. Rename this measure as Total Box Office unfiltered.

Create a quick measure to divide the Sum of Box Office Dollars by the previously created quick measure.

Rename this measure as % of unfiltered total and format it as a percentage.

Add the % of unfiltered total measure to the table visual.

Power BI Table visual with a Quick measure for percentage of unfiltered total

Unsurprisingly, the non Oscar winners have the highest percentage!

Add a slicer visual using Oscar Wins and set it to filter between 2 and 10 wins.

Power BI Table visual showing a filtered percentage value

The data being shown makes up 10.44% of the total Box Office value.

Now create a quick measure to show each Sum of Box Office Dollars value as a percentage of the filtered total.

Create a quick measure for the denominator giving the total value with filters applied.
Create a quick measure to divide the Sum of Box Office Dollars by the previously created denominator.