The numeric values of your measures can be aggregated directly inside the Planning Sheet. This episode pulls Selling Price in as a column from the Products table rather than a DAX measure, forces it from Average to Sum, and shows why the number immediately looks wrong - it is summing every row across all six row dimensions. Three routes lead to Manage Aggregation, where every measure in the sheet appears, displayed or hidden. Switch to Average Leaf and the number lands.
