Forum Discussion
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 at the moment is that we have more than 1000 clients on this matrix and I would like to easily identify those clients who are falling behind in the Market Share.
i.e. It could be a filter where it would ONLY display clients who have less than 50% market share with us the ABC CO.
This way I would not require to scroll down the matrix to identify these clients.
Have any of you come across something similar?
I would appreciate any assistance on this
Regards
Rodrigo
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
5 Replies
Seward12533Solution Sage
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
- RodrigoTXRA
Seward12533 this is perfect, I added this Share Measure into the filter and applied the amounts I wanted to see. Thank you very much for this
- RodrigoTXRA
Hey 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?
