For the most common and data-intensive report queries, always look to eliminate any unnecessary intermediate relationships between dimension tables and fact tables.
In the following example, the Reseller table must filter a hidden intermediate table (Reseller Keys) prior to filtering the Reseller Sales fact table:
Anti-pattern: intermediate table relationships
Removing the intermediate table (connecting flight), Reseller Keys in this example, significantly improves performance by reducing the scan operations required of the DAX query engine. The performance benefit is particularly acute with larger fact tables and dimensions ...
