Star Schema Done Right, Part 2: Dimension Tables and Why Cardinality Matters
A dimension table isn't just a lookup. Why fact-to-dimension relationships have to be many-to-one, why bidirectional filtering always causes problems, and how to build dimensions your DAX can trust.