How should you configure the relationships?

HOTSPOT

You have a Power BI model that has 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)

You plan to create the following measure.

Measure1 = DISTINCTCOUNT(Sales[ProductID])

You need to create the following relationships:

✑ Sales to Product

✑ Sales to Salesperson

The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.

How should you configure the relationships? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Graphical user interface, text

Description automatically generated

Latest PL-300 Practice Questions with 131 Q&As

Updated Study Material | Instant Download | Detailed Answers and Explanations

Subscribe
Notify of
guest
0 Comments