Sign in to watch this episode

Episodes are free for Fabric Planning Community members.

or
 · 
 · Episode 9
3:19 min

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.


Part of Planning · Season 1

The Introductory Voyage

The end-to-end first run. Stand up a Plan work item, point it at a semantic model, and build a Planning app people can actually type into, measures, notes, comments, formatting and roll-ups included.

View all 10 episodes
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.