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.
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 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]
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |