Constructing the Market Share Table

To achieve our goal, we will follow these steps:

1. Understanding the data table utilized
2. Implementing DAX for Market Size
3. Creating and styling the market share table

Happy learning!

1. Understanding the Data Table

We will refer to the following table for calculating market share:

Market_Share Table Overview:

• Product: Lists individual products (e.g., Product1, Product2).
• Category: Groups products into categories (e.g., A, B, C).
• Brand: Identifies the brand linked to each product (e.g., Brand1, Brand2).
• Sales: Displays sales figures for each product.

Key Observations:

• Category A: Brand1 offers three products with sales of 50, 30, and 18. Brand3 has two products with sales of 54 and 24.
• Category B: Brand2 features three products with sales of 65, 94, and 20.
• Category C: Brand4 has a single product with sales totaling 145.

This table is instrumental in visualizing the sales distribution across diverse products, categories, and brands, offering a comprehensive view of market performance.

2. DAX for Market Share

To calculate market share, we use the following DAX formula:

Market Share = DIVIDE(SUM(Market_Share[Sales]), [Market Size])

The DAX formula calculates the market size, which is elaborated in a concise article linked below:

3 easy steps for Calculating Market Size KPI in Power BI

Calculating market size is essential for businesses aiming to understand their potential customer base and revenue…

The only adjustment needed is to remove the Market_Share[Category] = “A” from the DAX for Market Size.

• SUM(Market_Share[Sales]): This segment of the formula calculates total sales from the Sales column in the Market_Share table, summing all sales values for the current context.
• [Market Size]: A measure that signifies the total market size, which should be pre-calculated.
• DIVIDE: This function handles division and manages division by zero elegantly. It divides total sales (the numerator) by market size (the denominator).

Here, SUM(Market_Share[Sales]) acts as the numerator, while [Market Size] serves as the denominator.

For additional information, refer to the following article:

2 easy steps to create Training Completion Rate KPI in Power BI

Power BI is a platform that allows you to connect to various data sources, transform and model your data, and create…

This DAX formula aids in identifying the share of total sales attributed to a specific brand or category, shedding light on its market share.

Sample Calculation

For products in Category A, the total sales amount to (98+78) = 176, which represents the market size.

For Brand 1 in Category A, the market share is computed as (98/176)*100 = 55.68%, while for Brand 3, it is (78/176)*100 = 44.32%.

3. Creating and Formatting the Market Share Table

Navigate to Visualizations and select Table under Build visual. Include Brand, Category, Sales, Market Size, and Market Share in the columns.

Next, right-click on Market Share, then select "Show value as" and choose "Percent of grand total."

Proceed to format the visual by turning off the Totals.

Expand the column headers, set the font size to 20, and adjust alignment as needed.

Choose the style of alternating rows in Style presets.

In the Values section, set the font size to 15 and adjust the colors as follows:

• Background color: #FFE77B
• Alternate background color: #D0B641

In the Specific column settings, apply alignment to the center for each column.

And finally, you will have your completed table.