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 ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
