Creating table for comparison between brands

[Anonymous]

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)

[NaveenGandhi]

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]

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]

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.