Percent point difference between 2 columns (expressed as % of grand total)

[Anonymous]

Hi 

I have the following data

Company	2017 sales	2018 sales
A	$40	$50
B	$60	$100
total	$100	$150

I've converted this to express market share, by choosing visualization as - express as % of grand total

Company	2017 share	2018 share
A	40%	33%
B	60%	67%
total	100%	100%

Now I want to get the following output

Company	2017 share	2018 share	Change
A	40%	33%	-7% pt
B	60%	67%	+ 6% pt
total	100%	100%

The problem is that I'm not able to get the difference to be expressed as percent point difference.

I'm currently using a Measure that os defined as : Change= 2018 share - 2017 share

This only expresses Change as either absolute $ difference in sales value OR

expresses this $ difference as % of row/column total. None of this delivers the desired output.

I'll appreciate any help on this!

[Anonymous]

@Anonymous  Please create following measures

Share 2017 = 
VAR Sales_2k17 = SUM(Test[2017 Sales])
VAR All_2017 = CALCULATE(SUM(Test[2017 Sales]),ALL(Test))
RETURN DIVIDE(Sales_2k17,All_2017,0)

Share 2018 = 
VAR Sales_2k18 = SUM(Test[2018 Sales])
VAR All_2018 = CALCULATE(SUM(Test[2018 Sales]),ALL(Test))
RETURN DIVIDE(Sales_2k18,All_2018,0)

Change = [Share 2018]-[Share 2017]