Hierarchies and groups are data model structures that can be implemented to simplify the user and report authoring experience. Hierarchies provide single-click access to multiple columns of a table enabling users to navigate through pre-defined levels such as the weeks within a given month. Groups are comprised of individual values of a column that enable analysis and visualization of the combined total as though it's a single value. Hierarchies and groups have useful applications in almost all data models and it's important to understand the relationship of these structures to the data model and visualizations.
This recipe provides an example of utilizing DAX parent and child hierarchy functions to create columns of a hierarchy. The hierarchy is then implemented into the data model and a group is created to further benefit...