DP-600 · 3.1.2 · Implement and manage semantic models
Semantic model star schema
Implement a star schema for a semantic model
Use dimensions for filtering and grouping, facts for , and clean one-to-many between them.
Build for filtering and summarizing
A works best when each table has one clear job. contain unique business entities and descriptive attributes used to filter or group. contain events or observations, their dimension keys, and numeric values.
The common is one-to-many from a dimension to a fact. Keep each fact table at one consistent .
Explicit then summarize the fact data in the current .
Key points
- Dimension: unique key plus descriptive attributes
- Fact: and dimension keys at one
- : filters flow from one side to many side
- Measures: explicit calculations summarize facts
Click an underlined term for a one-line explanation, or see them all in the glossary .
Exam trap
A single date table with one active and several inactive cannot filter two date roles at once. USERELATIONSHIP only switches the path inside one .
Sources · 2 Microsoft Learn pages Show ▾
Checked on October 4, 2026. Report a problem
Go deeper on Microsoft Learn
Checked against Microsoft Learn on October 4, 2026. Report a problem with this card