Market Share Percent In Ribbon Chart - % Of Column Total
We are trying to mimic The 100% stacked bar chart's % of column total calculation on a ribbon chart. So essentially a market share % of total calculation for each date we have. We've tried creating a measure that we thought would work but it has not: AllDivisionTracking := CALCULATE ( [TrackingNumbers], ALL ( Divisions ) ) PercentOfTotal := DIVIDE ( [TrackingNumbers], [AllDivisionTracking] ) This measure does not seem to work when inserted as the measure on a ribbon chart. The ribbon chart seems to make this calculation over the entire date range instead of limiting it to each day as we would have expected.
