|PowerPivot, DAX and Semi-additive measures|
|Written by Russell Christopher|
|Thursday, 21 January 2010 22:58|
Over the week-end I was doing some analysis on SQL Server disk usage, and wanted to be able to display current disk usage by database. Up to this point, I’d mainly been doing a SUM over my measures. Well, that would make no sense in this scenario – I’d end up with a meaningless number just like I would if I took a SUM of an Inventory value.
I found myself dealing with a classic semi-additive measure. These are easy to deal with using SQL Server Analysis Services, but a tiny bit trickier in PowerPivot.
- PowerPivot on the iPad: Best Practices
- Re-creating the PowerPivot Management Dashboard’s “Sliding Bubble Chart”
- Business Intelligence Indexing Connector “breaks” PowerPivot Gallery on “All in One” machine
- PowerPivot, DAX and Semi-additive measures
- SQL Server Reporting Services Reports in the PowerPivot Gallery
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?