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.
References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships