Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
548 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Software ==> | DAX (59 exercises) |
Topic ==> | The CALCULATE function (16 exercises) |
Level ==> | Average difficulty |
Subject ==> | Power BI training |
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.
Open the Music Tours - Calculate Replace Filters.pbix file in the folder shown above. On Page 1 you should see a matrix containing a list of subgenres.
Create a measure to show the average track length in seconds. You'll need to find the average of an expression which multiplies Track mins by 60 and adds Track secs to it.
Create another measure to compare the average track length in seconds with the same value where the subgenre equals pop. Add these measures to the matrix and apply some conditional formatting.
A sample of the results you should see.
Create the following measures to compare the average track length in seconds with other subsets of subgenres:
Measure name | Compare with |
---|---|
Avg track length vs. pop or rock | Tracks whose subgenre is either pop or rock. |
Avg track length vs. all pop or rock | Tracks whose subgenre contains the word pop or rock (you can use the CONTAINSSTRING function to do this). |
Display these measures in the matrix and apply some conditional formatting if you like.
A sample of the results you should see.
On Page 2 of the report you should see a chart showing the percentage of cancelled shows by year.
Wonder what that enormous spike in 2020 is all about?
Create a measure to calculate the percentage of cancelled shows when the Show[Show date].[Year] is either 2020 or 2021 and another measure to calculate the same value excluding these years.
Add these measures to the Y-axis bucket of the chart.
What a difference a year makes.
Save and close the report.
You can find other training resources for the subject of this exercise here:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.