Role-playing dimensions

Role-playing dimensions are an important part of the Kimball dimensional model, but implementing them in Power BI is not straightforward. Instead of copying tables several times, the appropriate technique is to use the USERELATIONSHIP() function in DAX to specify relationships on measures.

Each year, your company determines for each NAICS code its largest industrial business customer for that sector. As such, users can compare sales, revenue or number of employees between one sector and its related sector. This data is stored in a new dataset, called Summary Statistics Double NAICS. You are asked to create a report where users can quickly compare the number of employees per industry subsector.

If you have lost any progress, close any open reports and load 3_2_role_playing.pbix from the Exercises folder on the desktop.