Relative Market Share = Supplier’s Absolute Market Share/largest competitor’s Absolute Market Share The R elative 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. Total Volume = SUM(BCG) Total Volume LY = CALCULATE( PREVIOUSYEAR(BCG.)) Year On Year Growth Rate = DIVIDE(- 0) Absolute Market Share = DIVIDE(SUM(BCG) CALCULATE(SUM(BCG) ALLSELECTED(BCG))) The values for Year On Year Growth Rate and Absolute Market Share are calculated with the help of the following measures: The values for Year, Supplier and Volume directly come from my table BCG. My aim is to generate a table which looks like this (and afterwards transfer the values of this table to a X-Y-Scatter_Plot): My data model contains 1 Table (called BCG) with 3 columns (Year, Supplier, Volume) looking like this: Thank you so much for your reply and your suggestions.Īfter having read your article "How to Get Your Question Answered Quickly" (thanks for that hint!!), give me a chance and let me reframe my problem/question: I would really appreciate if someone could help me to come up with a solution on how to get the relative market share for each supplier for a given year.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |