Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating table for comparison between brands

Hello everyone,  I am trying to create a simple table to compare two brands (Mine vs Competitor) and I want to see it based on market share [KPI].  I have two tables one "Product" and "Challenger" ...
Need Help
NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago

Hi Anonymous 

It would be easy to understand the problem if you can share some sample data, screenshot of expected output and how you are visualizing this.

Thanks,
NG

Anonymous's avatar
Anonymous
Not applicable
1 year ago

This is the calculation of MS:
Market Share = DIVIDE([_Total Sales],[_Total Sales All Groups])
 
and this is: Total Sales All Groups_Guidence =
CALCULATE([_Total Sales without Total],
ALL('Product'[Group]),
ALL('Product'[GroupNew]),
ALL('Product'[Country_Categ_Group_Brand]),
ALL('Product'[Country_Categ_Group]),
ALL('Product'[Brand]))
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Hi,

    Share some data to work with, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.