Market share by cateogory

[junoglasgow]

I wish to make a Bar chart only showing specific brand M/S by category. Dataset consists as following;

Data name: Market

Column1: 5 Market Segment category

Column2: Brand with the list of several company brands

Column3: Year, just want to see 2018

Your help would be much appreciated!! 

[v-juanli-msft]

Hi @junoglasgow

From your another post which is related to this one,

https://community.powerbi.com/t5/Desktop/Market-share-by-category/m-p/538667

How do you calculate the percentage?

Chart1	BrandA		Chart2	BrandB		Chart3	BrandC		Chart4	BrandD
Entry	12%		Entry	13%		Entry	14%		Entry	11%
Main	13%		Main	15%		Main	13%		Main	10%
High	22%		High	24%		High	24%		High	27%
Premium	1%		Premium	2%		Premium	11%		Premium	11%
Luxury	6%		Luxury	5%		Luxury	62%		Luxury	16%

I make a test based on your table as below, but it seems not like yours.

Measure-> total Qty per Brand and per Market Segment, for example, for Luxury, total Qty for Brand A is 11

Measure2-> total Qty per Market Segment, for example, for Luxury, total Qty for all Brands is 29

Measure3->Measure/Measure2

Also Rank1 Brand~Rank4 Brand, and Brand A market share 74% in Entry / Brand A Market share 34% in Luxury / 85% market share in Premium are not clear to me.

(I made it as guided but it only shows % of Grand total. I want to see % of subtotal for a specific brand.

For example, Brand A market share 74% in Entry / Brand A Market share 34% in Luxury / 85% market share in Premium etc..)

Could you tell me how to calculate these percentage?

Best Regards

Maggie

[junoglasgow]

I fixed the example table, now they are in line with data. https://community.powerbi.com/t5/Desktop/Market-share-by-category/m-p/538667

[v-juanli-msft]

Hi @junoglasgow

Create measures to get the percentage you'd like

per brand = CALCULATE(SUM(Sheet1[Qty Sold]),ALLEXCEPT(Sheet1,Sheet1[Brand]))

PerMarket PerBrand = CALCULATE(SUM(Sheet1[Qty Sold]),FILTER(ALLEXCEPT(Sheet1,Sheet1[Market Segment]),[Brand]=MAX([Brand])))

MarketShare(%) ByBrand = [PerMarket PerBrand]/[per brand]

How do you create the bar chart? Is my bar chart right? This means which columns or measures you want to add in fields of bar chart?

Best Regards

Maggie

[MFelix]

Hi @junoglasgow,

Without any data is difficult to give you a specif response however you can do a filter on any visual on 3 different ways:

• Creating a slicer for each column you want to filter in this case Brand and Year
  
  • If you don't want user to change it after making the selections on the slicers hide them
• Adding the columns Brand and Year on visual level filter and selecting the values you need
• Creating a measure with the filters and using it as the values on your bar chart

  Measure =
  CALCULATE (
      SUM ( Table[column] );
      Table[Brand] = "Brand A";
      Table[Year] = 2018
  )

Be aware that creating the measure will make the values fix and to change them you need to change your report on the other options it's more flexible in terms of changing the selections.

Again without additional information is difficult to give you a better response.

Regards,

MFelix