Question

You have a star schema with a Sales fact table related to Product and Customer dimensions. A new requirement asks that slicing by Product also filters a separate Inventory fact table that shares the Product dimension. A colleague suggests setting the Sales-to-Product relationship cross-filter direction to 'Both' to make this work. What is the most likely consequence of enabling bidirectional cross-filtering on this dimension relationship?

Accepted Answer

It can introduce ambiguous filter paths and unexpected results when multiple fact tables share the dimension, and may degrade query performance.

Answer

It automatically reduces the model size by eliminating duplicate dimension keys.

Answer

It converts the relationship to many-to-many cardinality, which is required for any shared dimension.

Answer

It forces all measures to recalculate using DirectQuery instead of the import cache.