Percent of Whole, DAX Style
User Rating: 4 / 5
A common request in business analytics is determining the contribution of a subset to the entire population. For example:
- Which stores comprise the greatest share of sales?
- What products make up the least amount of volume?
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.