6. Geography Hierarchy

To allow our report to filter data by region, country and province/state, we created a geography hierarchy with the following levels: World Region > Country > Country Region. To do this, I had to first set up the following columns:

• New calculated column Country in the Stores table that creates a full country name for each row, based on the Stores[Country Code] column.

• New calculated column Full region in the Stores table, containing the values on the Stores[Country Region], and Store[Country] columns, separated by a comma and a space.