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