- Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
- Reza Rad
- 424字
- 2021-08-13 17:55:27
Time for action – creating measures
Tabular doesn't have any measures by default; this means that you need to add measures as required, but don't worry as creating measures is very easy in the model designer. In this example, you will see how to create measures such as Order Quantity or Sales Amount.
- Under the Model menu, select Analyze in Excel; in the dialog box, choose the current Windows user.
- You will see an Excel spreadsheet open, and in a PivotTable, all the tables from the current tabular model are listed. In the PivotTable fields list under Internet Sales, choose Sales Amount.
- You will see distinct values of the Sales Amount measure shown instead of a measure with the summary of all the sales amount. This is because there is no measure for the sum of the sales amount, and by default, all the values (even numeric ones) are shown as distinct values.
- In SSDT, go to the Grid View of the Internet Sales table. Click on an empty measure cell under the Sales Amount column, and then click on the sum icon (this will create DAX in the background, which will be covered later in this chapter). Do the same for Order Quantity (look at the following screenshot). Then, select the Sum of OrderQuantity measure, and in the Properties pane, change the format to a whole number and set show thousand separator as true.
- Save the changes and go back to the Excel spreadsheet. Uncheck Sales Amount and click on Refresh the PivotTable. Now, you will see a list of measures at the top of the PivotTable fields list; select Sum of SalesAmount and Sum of OrderQuantity from measures. Select Calendar Year under the date. Now, you will see how measures are shown in the designer sliced and diced by the calendar year.
What just happened?
In this example, you learned how to view the results of the tabular model in Excel with Analyze in the Excel option. This option will open an Excel spreadsheet with PivotTable that enables you to slice and dice data with different tables and shows measures in comparison to each other (described in steps 1, 2, 3, and 5).
You also saw how easy it is to create measures and configure properties such as format string for measures (step 4). Measures created based on expressions (shown in the screenshot after step 4) are written in the DAX language. DAX provides many functions, and you can enhance them to create complex expressions to create measures, as your business requires.
- Java語言程序設計
- Microsoft Exchange Server PowerShell Cookbook（Third Edition）
- Mobile Application Development：JavaScript Frameworks
- Learning Data Mining with Python
- C語言程序設計教程
- 微服務架構深度解析：原理、實踐與進階
- Kotlin進階實戰
- Mastering ASP.NET Core 2.0
- Spring Data JPA從入門到精通
- Oracle Database XE 11gR2 Jump Start Guide
- 例說FPGA：可直接用于工程項目的第一手經驗
- 自己動手構建編程語言：如何設計編譯器、解釋器和DSL
- Java EE 7 Development with WildFly
- Python實戰指南：手把手教你掌握300個精彩案例
- Clojure High Performance Programming