Calculating Market Share via DAX query

[IliaS]

Hi! 

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:

                    Market Share

Pens                  43%
     pen 1           100%

     pen 2           100%

     pen 3           100%

Pencils               29%

     penc 1          100%

     penc 2          100%

     penc 3          100%

expected to calculate market share for each name, not only for categories correctly

[v-shex-msft · Accepted solution]

Hi @IliaS,

It seems like a common measure total level calculation issue when you use it to handle multiple aggregations, you can take a look at the Greg’s blog to know to fix it:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Share some data (in a form that can be pasted in an MS Excel file or the PBI file itself) and clearly show the expected result.