Power BI Dax - How to Calculate Percentages Based on Column Total and Sub Groups

This video will show you exactly how to calculate percentages correctly down a column based on the column total and with sub groups. This video shows you when you would use percentages and how to calculate them correctly in Power BI!

Most videos on this subject on YouTube use out of date formulas that no longer work since updates in 2020 and 2021. This video was made with formulas that work on the latest versions of Power BI so you won't have to spend hours frustrated trying to figure out what's wrong with it. Everything works perfectly on all versions of Power BI!

We will cover building two easy DAX calculations for percentages. One for the column total and the other for sub groups - this will provide subtotals. I will explain to you the difference and why you might want the subgrouping - its very helpful when you use filters or slicers for those sub groups.

This video shows all code and how to load in every part. We use a simple and interesting clothing sales data set for the example. You will be able to build these and a professional looking dashboard upon completion!

I hope you found this video helpful. Please take a moment to subscribe, like and share!

Thanks again and God Bless!