Calculation on dax (Urgent)

[Nihed]

Hello,

Who can help me on this urgent subject please,

I have a table that contains the following data on power BI

my request is :

Calculate each Employee Group’s Headcount change per year as a percentage comparing to prev year.

how I can do this calculation on dax for final objective to make this visual?

[daXtreme · Accepted solution]

File attached

[Nihed]

@daXtreme  I’m really happy it works super well thank you very much🙂

[BeaBF]

@Nihed Hi! Can you paste some sample data?

BBF

[Nihed]

I share with you an example for my data

Calendar year	Headcount	Employee Group	Directorate
2013	10	Temporary	SGE
2013	13	Official	EXD
2017	12	Official	CTP
2017	10	Official	DAF
2017	13	Temporary	EDU
2014	11	Official	EDU
2014	10	Temporary	EDU
2015	10	Official	NEA
2016	13	Official	EXD
2016	15	Temporary	EDU
2017	10	Official	EDU
2017	11	Official	ELS
2017	10	Official	GOV
2018	12	Temporary	GOV
2018	10	Official	NEA
2019	10	Temporary	CFE
2019	12	Official	EXD
2020	10	Temporary	GOV
2020	11	Official	GOV
2020	10	Official	GOV
2021	11	Official	EXD
2021	15	Official	CTP
2021	11	Official	STI
2022	10	Official	EXD
2022	11	Official	EXD
2022	11	Associated staff	CTP
2022	15	Official	CTP
2022	14	Official	CTP
2022	13	Temporary	EDU

[BeaBF]

@Nihed can you paste a table with the expected results? I can't understand how you obtain 12,5% for example in the first chart for 2013.

BBF

[Nihed]

I share with you the link to download the correct file:

https://we.tl/t-6g3kvoLsad 

[BeaBF]

@Nihed Access is denied. Try this measures:

MEDIA = CALCULATE(MEDIAN('Table'[Headcount]), ALLEXCEPT('Table','Table'[Calendar year],'Table'[Employee Group]))

PREVYEAR =

VAR YYEAR = SELECTEDVALUE('Table'[Calendar year])

VAR PREVYEAR = YYEAR - 1

RETURN CALCULATE([MEDIA],'Table'[Calendar year] = YYEAR) - CALCULATE([MEDIA],'Table'[Calendar year] = PREVYEAR)

BBF

[Nihed]

It doesn’t work I have the Media measurement equal 0

[BeaBF]

@Nihed Try to attack here your pbix file 

[Nihed]

how I can do it I don’t know how,if you can do it yourself I’d be grateful 

[BeaBF]

@Nihed 

[Nihed]

I couldn’t have sent you this I’ve been sitting for a while and it’s not working