Note: This question it part of a series of questions that use the same scenario. For your convenience, the scenario is repeated In each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
The Oder table contains more than one million rows.
The Store table has a relationship to the Monthy_returns table on the StoreID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You plan to create a chart that displays total Order [Order_amount] by Store [Name].
You need to modify the model to ensure that you can create the chart.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A . To the Order table, add a column that user the RELATED(‘Store’[Store_ID]) DAX formula.
B . Create a relationship between the Order table and the Store table.
C . To the Order table, add a measure that uses the COUNT(‘Order’[Order_amount]) DAX formula.
D . To the Order table, add a measure that uses the SUM(‘Order’[Order_amount] ) DAX formula.
Answer: BD
Latest 70-778 Dumps Valid Version with 147 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund