Create Clustered Colum with each cluster total 100%

[Anonymous]

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%

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

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