YoY Change of % Market Share

[sobsawats]

Hi Everyone

I am finding how to calculate YoY Change of % Market Share . I have 5 brands and it sales amount in 2015 and 2016. I can display %market share of brand by year but cannot find the way to calculate change (2016-2015) of market share of each band (the far right column in the picture). 

Please kindly advise. Thank you very much

Regards,

Sobsawat S.

Brand	Sales2015	Sales2016
A	2902	2998
B	2191	2180
C	4862	4480
D	4797	3315
E	1379	1003

[sobsawats · Accepted solution]

Hi all,

I got some idea and solved it by myself. Let me share with you and welcome any comment or better solutions.

Here is raw data

I created 2 measures to calculate market share for year 2015 and 2016 ;

MktShare2015 = DIVIDE(SUM(mktshare[Sales2015]),CALCULATE(SUM(mktshare[Sales2015]),ALL(mktshare[Brand])))

MktShare2016 = DIVIDE(SUM(mktshare[Sales2016]),CALCULATE(SUM(mktshare[Sales2016]),ALL(mktshare[Brand])))

and create another measure to see diff of above 2 measures which is my end result (YoY Change of % Market Share) ;

MktShareChg = mktshare[MktShare2016]-mktshare[MktShare2015]

DONE

[Birdjo]

Hello @sobsawats

Here's how you can calculate the percentage YoY % change in Power BI:

YoY change =
DIVIDE ( ( [This year data] - [Last year data] ), [Last year data], BLANK () )

Then you can go to the Modeling tab and set the measure as a percentage:

I hope this works well for you. 🙂

[sobsawats]

HI @Birdjo

Thank for sharing. Your solution and sample of DAX are great but not fit my problem. I might have an unclear problem statement but I can resolve it now.

Thanks again

Sobsawat S.