Demo: Cross filters in the AdventureWorks model
The demo shows how incorrect cross filter directions in the AdventureWorks snowflake model produce identical subtotals for every city, and how setting the cross filter to double on specific relationships fixes revenue calculations by allowing filters to propagate through mapping tables.
Previous Module
Clean, Transform and Load Data
This Module
Model Data