Percent of column Total

[Micnorex]

Hi! Could anyone show me how to show a percent of column total in my chart? I only have the choice % of grand total. I would like to show the percent of column total as in the matrix table (screen shot). Please? Best regards Michael

[v-ljerr-msft · Accepted solution]

Hi @Micnorex,

If I understand you correctly, you should be able to use the formula below to create a new measure to calculate the percent of column total, and show the measure as Values on the Chart to get the expected result in your scenario. 

Measure =
DIVIDE (
    COUNTA ( 'Sheet1'[Number] ),
    CALCULATE ( COUNTA ( 'Sheet1'[Number] ), ALL ( 'Sheet1'[Alder] ) )
)

Regards

[Micnorex]

Thank you, that made the trick. Really appreciate it!