The Customers table contains the following fields:

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.

Show Answer Hide Answer

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