Fact Table

There is always a table in the data model called Fact Table. This is the starting table whose records always get returned regardless of whether there are corresponding records in the other linked tables.

This table is labeled with the keywords Fact Table above the table name. By default, the first table added to a data model is set as the fact table.

It is possible to override this table by right-clicking one of the other tables and selecting Set as Fact Table.