Active and inactive relationships
Sales connects to Date through both OrderDate and DeliveryDate,
but only one relationship can be active. The sales team needs Revenue
counted by order month, and logistics needs Deliveries counted by delivery
month.
The app shows the model and the month each measure counts each order in. Try each combination of the active relationship (step 1) and the USERELATIONSHIP switch (step 2). Which setup lets the sales team see revenue by order month and logistics see deliveries by delivery month?
This exercise is part of the course
Data Ingestion and Semantic Models with Microsoft Fabric
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise