How to calculate a percentage per year, not by grand total ?

[Anonymous]

Hello, 

I am beginner in Power BI and I have an issue to calculate a percentage. It is systematically calculated considering all the years whereas I want the percentage of each category per year, can you please help me ? 

Here are my data : 

Value	MoyenLocomotion	Annee	Percentage I want (% by Total of the year, not by Grand total)
6	A Pied	2017	=6/46 = 13%
1	Moto	2017	=1/46 =2%
39	Voiture	2017	=39/46 = 85%
5	A Pied	2018	=5/54 =9%
3	Moto	2018	=6%
46	Voiture	2018	85%
9	A Pied	2019	13%
3	A Vélo	2019	4%
2	Autre	2019	3%
4	Moto	2019	6%
2	Transport Public	2019	3%
50	Voiture	2019	71%
1	A Pied	2020	14%
1	Autre	2020	14%
5	Voiture	2020	72%
Grand Total : 177

Can you please help me to build the measure to get this info please ?

Thanks a lot, AnSo

[harshnathani · Accepted solution]

Hi @Anonymous ,

You can try these measures.

Total Value = SUM('Table'[Value])

Percentage =

var _totalvalyear = CALCULATE(SUM('Table'[Value]) , ALLEXCEPT('Table','Table'[Annee]))

RETURN

DIVIDE([Total Value],_totalvalyear)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)