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" - in challenger i have my competior brand. I combined these two based on the multiple conditions (KEY) - i do not have any duplicates in "Challenger" so it is - Mayn to one relation. 

I am using these two calcualations: 

1. working correctly. Taking the brand from "product" table - i see correct numbers

_Selected brand =
var SelectedBrand = SELECTEDVALUE('Product'[Brand])
return
CALCULATE([KPI],
'Product'[Brand]=SelectedBrand)

2. i have only blanks. Taking the competitor brand from "challenger" 

_Selected brand comparison =
//var SelectedBrandComp = SELECTEDVALUE('Product'[Brand])
var SelectedBrandComp = SELECTEDVALUE(Challenger[Competitor Benchmark Brand])
return
CALCULATE([KPI],
'Product'[Brand]=SelectedBrandComp)
Need Help

3 Replies

  • 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.