When using the Advanced Drill Down Column Chart in Power BI, I have a calculated measure that is showing the SUM as it goes up in Hierarchy or Zooming Out, as opposed to running the DAX Measure at that value.
This DAX measure calculates a competitive win rate as a percentage. It works fine at the base level ( different levels of Revenue Groups), but as I zoom out to a higher level; it sums the individual values rather than giving me the DAX measure calculation at that level.
for example, at the $500K groups it works fine, at $1M groups it sums all under, and at $5M groups it sums all under as well.
It seems like giving an option for each Stack to decided if you want it to do aggregation by Sum, Avg, Min, or Max might solve this?
The DAX measure for Win Rate works fine alongside the % of Grand Total values in the Line and Clustered Column chart visualization built into Power BI. I just prefer to use ZoomCharts with Area Curves and a Line instead.