A data modeler is developing a semantic model in Microsoft Fabric. The model includes a 'Customers' table and a 'Sales' fact table. The business requirement states that when filtering by 'Customer Region' in a report, sales for that region should be displayed, but the filter should also propagate to a 'Marketing Campaigns' table to show which campaigns were active in that region. However, filtering 'Marketing Campaigns' should NOT affect 'Customers' or 'Sales'. Which cross-filter direction should be configured for the relationship between 'Customers' and 'Marketing Campaigns'?
- ANone
- BSingle (Marketing Campaigns filters Customers)
- CSingle (Customers filters Marketing Campaigns)
- DBoth
Show answer & explanationAnswer & explanation
Correct answer: C. Single (Customers filters Marketing Campaigns)
The requirement states that filtering 'Customer Region' (which filters 'Customers') should propagate to 'Marketing Campaigns', but filtering 'Marketing Campaigns' should not affect 'Customers' or 'Sales'. This indicates a unidirectional filter flow from 'Customers' to 'Marketing Campaigns', which is achieved with a 'Single' cross-filter direction where 'Customers' is the 'one' side filtering the 'many' side, 'Marketing Campaigns'.
Why the other options are wrong
- A. A 'None' direction would prevent any filtering between the tables, which contradicts the requirement to filter 'Marketing Campaigns' by 'Customers'.
- B. This direction would allow 'Marketing Campaigns' to filter 'Customers', which is explicitly disallowed by the requirement.
- D. A 'Both' direction would allow 'Marketing Campaigns' to filter 'Customers', which explicitly contradicts the requirement.
Cross-filter Direction
Cross-filter direction in a semantic model relationship dictates how filters propagate between related tables, either unidirectionally (Single) or bidirectionally (Both), impacting report interactions and calculation results.
- Controls filter flow between tables.
- Single (One-Way): filter propagates from 'one' side to 'many' side.
- Both (Two-Way): filter propagates in both directions, use cautiously.
Memory trick: Filter Flow: Choose Your Path, Single or Both!