Forum Discussion
RodrigoTXRA
Helper I
Helper IWarning when Market Share falls below
Please see Sample Data through this link Hi All I have a matrix where it displays my clients and how much they have purchased with us as well as with competitors. The challenge that I have...
Rather than use % Row total you need to write a few measures.
Revenue = SUM(Dashboard[Base Amount]) Share = CALCULATE([Revenue],Dashboard[Bought_from_us_or_Competitor]="ABC CO") / [Revenue]
With these measures and using [Share] in your visual you can sort by Market Share and put the lowest on top. See link
Seward12533
Solution Sage
Solution SageRather than use % Row total you need to write a few measures.
Revenue = SUM(Dashboard[Base Amount]) Share = CALCULATE([Revenue],Dashboard[Bought_from_us_or_Competitor]="ABC CO") / [Revenue]
With these measures and using [Share] in your visual you can sort by Market Share and put the lowest on top. See link
RodrigoTXRAHelper I
Helper IHey Seward12533 have you used What If analyses in Power BI?
Lets say now that I am able to display only those companies which are falling behind in market share, would we be able to analyse those clients by asking power bi to display how much revenue would shift towards my company if my Market share increased 5%?
- Seward12533Isnt that just .05*[Revenue] since that represents the total available market?
- Seward12533For the what if you could also create a disconnected sliver of percentage amounts and then use SELECTEDVALUE to harvest the user selection and then use that as the percentage.
Since this is a numeric number you could use the New Parametrr button on the Modeling Tab to create both the lookup table and harvest measure for you automatically.