gospelwhe.blogg.se

variable 1: highest absolute market share for the given year.Relative market share of supplier C = 0,37 / 0,42 = 0,88 Relative market share of supplier B = 0,42 / 0,37 = 1,14

Relative market share of supplier A = 0,21 / 0,42 = 0,5 Relative market share = supplier’s absolute market share/largest competitor’s absolute market share The relative market share should be calculated for a given year and is defined as: What I am struggeling with is the calculation of the relative market share. Year, Supplier and Volume directly come from my data table. So far, I managed to calculate the year on year growth rate and the absolute market share with DAX. To accomplish this, I need to obtain the following data (sample): The end result should look something like this (however, it might not be realized to connect the different dots for the different years with a line): My goal is to build a BCG (Boston Consulting Group) Matrix in Power BI which shows the combination of relative market share and year on year growth rate of different suppliers for selected years in a X-Y-scatter-plot (each of these combinations per supplier is represented by a colored dot per year). I'm pretty new to Power BI and struggle with the following problem: