Forum Discussion

sastrup's avatar
sastrup
Regular Visitor
7 years ago
Solved

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 creati...
CALCULATE
column total
DAX
powerbi
ribbon
stacked bar
  • matsder's avatar
    matsder
    7 years ago

    Taking deldersveld solution into consideration a ribion chart with Market Share Trends can be created. I used the formulas below and tested it for accuracy and it seems to work:

    AllDivisionTracking := CALCULATE ( DistinctCount([TrackingNumbers]),FILTER(DateTable,DateTable[Date]), ALL ( Divisions ) )

PercentOfTotal := DIVIDE ( DistinctCount([TrackingNumbers]), [AllDivisionTracking] )

    I added an external date table that was used in the calculation.