How to do it...

To implement this recipe, do the following:

1. Create a column in the R02_Project table using the following formula:

Planned Value = 
    VAR __Table = 
        ADDCOLUMNS(
            ADDCOLUMNS(
                RELATEDTABLE('R02_Assignments'),
                "__Cost_Per_Hour",
                RELATED('R02_Resources'[Cost_Per_Hour])
            ),
            "__PV",
            [Scheduled_Work] * [__Cost_Per_Hour]
        )
RETURN
    SUMX(__Table,[__PV])

2. On a Report page, create a matrix visualization and place the Project, Phase, and Name columns from the R02_Project table into the Rows area with the Project column being at the top, then the Phase column, and then the Name column at the bottom.
3. In the same matrix visualization, place the Planned Value column from the R02_Project table into the Value area.