I am trying to calculate market share, but struggling with doing it correctly.
I have a matrix where I have Category, Name as rows, Channel as column, and Market Share as value.
Also In my dataset I have columns ABS_COMPANY (with sales inputted there if company = "A", so there are some blank ones), and ABS_TOTAL (with sales inputted in each row)
so my measure Market Share:
Market Share = SUM(table[ABS_COMPANY]) / SUM(table[ABS_TOTAL])
This correctly calculates values for each Category, but when I open the drop-down to see Name, Market Share of each Name equals to 100%. What is the problem and how to fix it?
e.g. What is now:
pen 1 100%
pen 2 100%
pen 3 100%
penc 1 100%
penc 2 100%
penc 3 100%
expected to calculate market share for each name, not only for categories correctly