070-466日本語 無料問題集「Microsoft Implementing Data Models and Reports with Microsoft SQL Server (070-466日本語版)」
DRAG DROP
正解：
Explanation: Box 1:
Box 2:
Box 3:
Note:
* (Step 1, step 2): The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.
* Step 3: The KPI has the following requirements.
*If the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red).
*If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow).
*If the rate of production of defective products less than 2% then the KPI must report a status of on target (green).
DRAG DROP
正解：
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* In the model designer, in Data View, select the table to which you want to add a calculated column, then click the Column menu, and then click Add Column.
* To create a new calculated columnAdd Column is highlighted over the empty rightmost column, and the cursor moves to the formula bar.
To create a new column between two existing columns, right-click an existing column, and then click Insert Column.
* In the formula bar, do one of the following:
* Press ENTER to accept the formula.
* Calculated columns, in tabular models, allow you to add new data to your model. Instead of pasting or importing values into the column, you create a DAX formula that defines the column's row level values. The calculated column can then be used in a report, PivotTable, or PivotChart as would any other column.
* A calculated column is DAX expression that creates a new column in a table and the obtained values are stored in the table; the calculated column expression is evaluated every time the table is processed.
* In tabular object models the calculated column is a column in a table whose values are calculated upon definition of the column, from an expression.
