Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
Thank you, its worked for me.
I ll use without the "filter".
you are welcome
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |