pl-300beginner

Fact vs Dimension

A simple way to tell the difference between fact tables and dimension tables in Power BI.

Mar 27, 20261 min read

Fact tables

Fact tables usually store events, transactions, or measurements.

Dimension tables

Dimension tables usually store descriptive attributes used to slice and group facts.

Rule of thumb

If the table answers "how much" or "how many," it is often a fact. If it answers "which one" or "what kind," it is often a dimension.

Related posts

pl-300beginner

Star Schema Explained

Learn what a star schema is, why it matters in Power BI, and how it appears in PL-300.

Mar 30, 20261 min read