From the course: SQL Server Analysis Services
Join today to access over 24,600 courses taught by industry experts.
Solution: Calculate measures - SQL Server Tutorial
From the course: SQL Server Analysis Services
Solution: Calculate measures
(upbeat music) - [Instructor] After you have completed all the steps outlined in the challenge video, you should have an Excel file. That Excel file for the solution is included in the exercise file in Chapter 3. In the End section, I'm going to double-click in the 03_05e Excel file to open it up. You will always get security warnings for external data connections in Excel, so you can just go ahead and close this to ignore it. Notice that for the KeepFilters function, you only have values where the sales territory matches Great Lakes, but in the Great Lake Quantity measure, where you've not added the keep filters, you have the same value for every single sales territory, whether or not that is Great Lakes or not. So these do work very differently. Notice that all of these are formatted with commas. Let's take a look at the analysis services project in Visual Studio and review where we've put the DAX measures and how to…
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.