From the course: SQL Server Analysis Services
Join today to access over 24,600 courses taught by industry experts.
Challenge: Calculate measures - SQL Server Tutorial
From the course: SQL Server Analysis Services
Challenge: Calculate measures
(upbeat music) - [Instructor] In this challenge, we are going to write a few DAX measures and then test them in Excel. We'll be starting in the chapter three Begin project. I'm going to go ahead and open up the SLN file to open up the project in Visual Studio. We're going to be using the column Fact Sale quantity and aggregating it using the DAX count function. We'll also be making sure that we format all of our DAX measures. We'll be curating three measures. The first one will be called total quantity, and it's going to be count of the fact sale quantity. The second measure is going to use the first measure and calculate the total quantity using a calculate statement filtering on the sales territory of Great Lakes. The third measure is going to be very similar to the second one except this time we are going to in to see how this filter changes the way that it works within Excel when it's being used. Make sure you…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.