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.
Hot Area:

microsoft-exams

2 thoughts on “How should you configure the relationships?

    1. The measure DISTINCTCOUNT(Sales[ProductID]) is created in the fact table (to know different products sold on a particular day, for example. The different products in the dimension, which may be a lot and have never been sold, are of no interest).
      As there is a direct relationship between Fact and DimSalesPerson, a Single relationship is enough to see that Measure for each Salesperson.
      I’ve tested it with AdeventureWorksDW2012 excel and creating a table in PowerBI, with DimCustomer[FullName] and DistinctCountProductKey = DISTINCTCOUNT(FactInternetSales[ProductKey]) and ‘Single’ works to see both fields in a table.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.