You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails.
The primary key of DimCustomer is CustomerID.
FactOrderDetails contains a column named CustomerID that can be used to relate to DimCustomer. Multiple rows in FactOrderDetails possibly have the same CustomerID value.
You need to create a relationship from FactOrderDetails to DimCustomer. The solution must optimize query performance.
What should you create?
kay000001
1 week, 1 day ago