What should you configure?
HOTSPOT
You have two tables named Customers and Invoice in a Power BI model.
The Customers table contains the following fields:
✑ CustomerID
✑ Customer City
✑ Customer State
✑ Customer Name
✑ Customer Address 1
✑ Customer Address 2
✑ Customer Postal Code
The Invoice table contains the following fields:
✑ Order ID
✑ Invoice ID
✑ Invoice Date
✑ Customer ID
✑ Total Amount
✑ Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
✑ The number of customers invoiced in each state last month
✑ The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Box 1: One-to-many
A customer can have many invoices within one month.
Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.
Latest DA-100 Dumps Valid Version with 114 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund