Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create Clustered Colum with each cluster total 100%

Currently have a 100% stacked column chart:

 

 

Built in functionality gives % of total sales. 

 

Users would like to see this as a Clustered Column Chart with each age group totaling 100%. Example: For the 18-34 age group, the total of the 5 Plan Name Net units will equal 100%

  • Anonymous , Try a measure like

    divide([net units], calculate([net units], allexcept(Table, Table[Age groups])))

1 Reply

  • Anonymous , Try a measure like

    divide([net units], calculate([net units], allexcept(Table, Table[Age groups])))