How to do it...

To complete this recipe, do the following:

1. Create the following measure:

Occupancy % = 
    VAR __Table = 
        SUMMARIZE(
            'R07_Table',
            'R07_Table'[Country],
            'R07_Table'[Hotel],
            "Aggregation",MIN('R07_Table'[% Occupancy])
        )
RETURN
    SWITCH(TRUE(),
        ISINSCOPE('R07_Table'[Date]) || 
            ISINSCOPE('R07_Table'[Hotel]),MIN('R07_Table'[% Occupancy]),
        ISINSCOPE('R07_Table'[Country]),AVERAGEX(__Table,[Aggregation]),
        MAXX(
            GROUPBY(
                __Table,
                [Country],
                "GTAggregation",
                AVERAGEX(CURRENTGROUP(),[Aggregation])
            ),
            [GTAggregation]
        )
    )

2. On a Report page, create a Matrix visualization and place the  Country and Hotel columns from the R07_Table table into the Rows area of the visualization with Country at the top and Hotel at the bottom.
3. In the same Matrix visualization, place the Occupancy % measure into the Values area of the visualization.
4. Right-click the UK cell and choose Expand and then All.