Introduction
In Day 18, you learned how to track cumulative performance using Running Totals to understand how sales build over time.
But businesses also want to know something equally important.
Which products, regions, or categories contribute the most to total revenue?
Instead of only looking at raw sales numbers, analysts often calculate Percentage of Total to understand contribution.
In Day 19, you will learn how to calculate contribution percentage so your dashboard can clearly show which areas drive the business.
What You Will Learn Today
You will calculate Percentage of Total using DAX
You will identify top contributors in your data
You will visualize contribution clearly in charts
You will understand how businesses prioritize high-impact areas
Why This Skill Matters for Your Career
Companies constantly ask questions like:
Which product generates the highest revenue?
Which region contributes the most to sales?
Which category drives overall business performance?
Absolute values don’t always answer these questions clearly.
Percentage contribution shows the relative importance of each component, helping managers allocate resources effectively.
This is commonly used in sales analysis, product performance reports, and financial dashboards.
Understanding Percentage of Total in Simple Terms
Imagine a company generates ₹1,00,000 in sales.
If:
Laptops → ₹50,000
Monitors → ₹30,000
Accessories → ₹20,000
Their contribution would be:
Laptops → 50%
Monitors → 30%
Accessories → 20%
This tells you instantly which product category drives the majority of revenue.
How This Connects to Previous Days
You already created:
Total Sales
Growth comparisons
YTD analysis
Running totals
Now you will analyze contribution, which helps explain where revenue actually comes from.
This completes another key dimension of business analysis.
Step-by-Step: Create Percentage of Total Measure
Go to Modeling → New Measure.
Write the following formula:
Sales Contribution % =
DIVIDE(
[Total Sales],
CALCULATE(
[Total Sales],
ALL(Sales_Data)
)
)
Press Enter.
Now change the format to Percentage.
Power BI will calculate how much each row contributes to the overall total.
What This Formula Is Doing
The denominator removes filters using ALL() so Power BI can calculate the grand total.
Then it divides each row’s sales by that grand total to determine contribution.
Step-by-Step: Visualize Contribution
Create a Table or Matrix with:
Product
Total Sales
Sales Contribution %
You will now clearly see which products drive the largest share of revenue.
Alternative Visual: Pie Chart
You can also create a Pie Chart with:
Legend → Product or Category
Values → Total Sales
This visual automatically shows contribution percentages.
However, tables with percentages often provide clearer insights in professional dashboards.
Common Beginner Mistakes to Avoid
Do not forget to format the measure as Percentage.
Avoid using ALL() incorrectly — ensure it refers to the correct table.
Do not rely only on pie charts; contribution tables are often easier to analyze.
Try This Yourself
Create a bar chart with:
Axis → Product
Values → Sales Contribution %
Sort the chart in descending order.
You will instantly see which products dominate revenue.
How Today Builds on Previous Days
Day 16 → Cumulative yearly tracking
Day 17 → Year-over-Year comparison
Day 18 → Running totals
Today in Day 19, you analyzed contribution and share.
Your dashboard can now explain trend, growth, accumulation, and contribution — four key perspectives in business analytics.
What Comes Next
Next, you will learn how to identify Top and Bottom performers dynamically using ranking functions, helping decision-makers focus on the most important insights.
Stay Connected and Keep Practicing
Blogs WhatsApp Channel (for daily quizzes and blog updates):
https://whatsapp.com/channel/0029VbCcWME4inotCWmN5511
Telegram Channel (Job Updates & Career Alerts):
https://t.me/careervalore
WhatsApp Channel (Daily Job Updates):
https://www.whatsapp.com/channel/0029Vay7sUV11ulUIhLBUI44
Conclusion
Today you learned how to calculate Percentage of Total in Power BI.
By analyzing contribution instead of just raw values, your dashboard now highlights the areas that truly drive business performance — an insight every manager looks for.
Leave a Reply