Analyzing and Visualizing Data with Microsoft Power BI — Question 133

You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables:
✑ Product (Product_id, Product_Name)
✑ Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
✑ Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
✑ Sales to Product
✑ Sales to Salesperson
You create a new Power BI file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson.
What should you do before you create the report?

Answer options

• A. Create a one-to-one relationship between Product and Salesperson.
• B. For each relationship, change the Cross filter direction to Both.
• C. For each relationship, change the Cardinality to One to one (1:1).
• D. Change a many-to-one relationship between Product and Salesperson.

Correct answer: B

Explanation

The correct answer is B because changing the Cross filter direction to Both allows for the correct aggregation of data between tables, enabling the report to accurately count products sold by each salesperson. Options A and C suggest incorrect relationship types that do not apply to the existing data model, while D does not address the necessary filtering needed for the report.