How create a measure to show percentage of a category per month in a stacked column chart?

[fellipea_ao]

Hello!

I'm trying to create a measure to show a percentage of category per month in stacked column chart.
First, I created a measure to show the percentage of total and showed it in tooltip:

%QTD_TotalCateg = 
var num = count('Planilha 1'[Aplicabilidade]) 
var denom = calculate(count('Planilha 1'[Aplicabilidade]), ALLSELECTED()) 
return divide (num,denom,0)

Ex: 2 "No" in April = 6.67% of total (2/30)

Now I want to know how to create a measure that show percentage of total of month to show in tooltip.

Ex: 2 "No" in April = 33.33% of total of April (2/6)

data: https://docs.google.com/spreadsheets/d/1ywn_YinYVXll-fFE0yBOdwr0ZWi1g_ek/edit?usp=sharing&ouid=10871...

[ryan_mayu · Accepted solution]

@fellipea_ao 

pls try this. i didn't change the measure type, you can change it to percentage.

Measure = countx(FILTER('Table','Table'[Aplicabilidade]="No"),'Table'[Aplicabilidade])/CALCULATE(COUNT('Table'[Aplicabilidade]),ALLEXCEPT('Table','Table'[Mês]))

pls see the attachment below

[fellipea_ao]

Thank you, its worked for me.

I ll use without the "filter".

[ryan_mayu]

you are welcome