| Percent of Whole, DAX Style |
| Written by Barry Ralston |
| Friday, 16 July 2010 01:28 |
A common request in business analytics is determining the contribution of a subset to the entire population. For example:
This sort of ranking and sorting generated complex, correlated sub-queries in the relational world, but are actually quite elegant when solved using an OLAP implementation. My most recent PowerPivot project involved just such a requirement in a commodity, agri-business. In appreciation of my client’s confidence, I have literally changed the names to protect the innocent, in order to illustrate the problem and solution.
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
