PowerPivot: Calculate ratio to parent
With SQL 2012 PowerPivot we have hierarchies at our disposal, one of the most common calculations we want to do with those hierarchies is doing a ratio to parent. This blog describes how you to do that.
I started with two simple tables, one a team / chapter table, the other sales by chapter:
Read more...Tags: powerpivot, dax, tabular