Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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.

  1. Under the Model menu, select Analyze in Excel; in the dialog box, choose the current Windows user.

  2. 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.

  3. 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.

  4. 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...