How to Calculate Percentages in Power BI based on Column Total and Parent Row💯

How to Calculate Percentages in Power BI based on Column Total and Parent Row

In this lesson, we will learn how to calculate Percentages in Power BI based on column total and parent row.

Navigate through the content below:

0:33 Agenda
1:03 DAX functions to be successful in this tutorial
2:11 Percentages based on column total
3:30 Percentages of parent row
4:20 Case

___________Highly recommended Power BI books (Affiliate links):
***Collect, Combine, and Transform Data Using Power Query in Excel and Power BI:

___________Relevant PBI Topics
____________

[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.

___________Please follow us on:

Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!

#DAXTips #PowerBI #vizxlization #PercentagesinPBI

[manassehkisame]

One of the simplest way to teach and reach the mind...

[DataAdminPharmacyPmg]

Thank you very much for the knowledge you have provided.

[bzflowerbee]

Excellent! This is just perfect for the report that I have been working on. I have to calculate the overtime, unplanned hour, vacation for each locations. Thanks again!

[balajiawari]

If the column data is to shown with months, and If I write a measure for Percentage, then the percentage is showing for all the months, but I want to show only at the end, Any solution for this sir

[soniaevwoja]

Thank you Nestor. Exactly what I needed.

[kathychiha]

Thank you so much!! I have been looking for this solution for such a long time & your direction gave me exactly what I needed :)

[IvanCortinas_ES]

Excellent tutorial Nestor, as usual. Thank you for your super explanations!

[azizdahduli]

Why are you using the values function for the product column when that column isnt being used in the visualization, can you explain please. thank you

[pavanranapanga]

Excellent, I m working on same type of project. 👍👍👍

[souravsha]

I have a similar requirement. But my Product column is in another dimension table with 1 to Many join on the fact table.
Following this, the calculation is being done based on grand total and not column total. Could you please help with that?

[richardostrea]

Is it possible to create a percent of parent row total in combination of new field parameters?

[bzflowerbee]

Hi Arianzen, i have watched this video a hundred times and I followed every step and things turned out to be exactly what I wanted. However, when I converted to the bar chart, everything turned to 100% for the Parent Row. Why? Can you tell me please? Thanks.

[prabakaran]

Hello Nestor, im beginer for Powerbi. I have a quick question.
In my report I have 17category 5countries and each countries has morethan 7supplier, I need to identify % of the supplier performed for each category, whic means my cal should be supplier value for each category and country / total calegory *100 how should i perform in powerbi ?

Im using metrix table : Category, country and supplier ive taken in the column, values in row.

Ex
Category : sales. :Share
1 Chocolate. 10000. 100%
India. 5000. 50%
Sup A. 3000. 30%
Supp B. 2000. 20%
Srilanka. 2000. 20%
Supp A. 1000. 10%
Supp B. 1000. 10%
Australia. 2000. 20%
Supp A. 500. 5%
Supp B. 1500. 15%
NZ. 1000. 10%
Supp A. 1000. 10%
2. Biscuit. 20000. 100%
Turkey. 10000. 50%
Supp A. 5000. 25%
Supp B. 5000. 25%
India. 10000. 50%
Supp A. 6000. 30%
Supp B. 4000. 20%


This is wat i expect, kindly assist me

[samtmayen]

Thanks for the video. Is there a way to do Parent Row % not with only 1 level but with more? 3-4 levels?

[decentmendreams]

Thanks. Question. Could you add time columns on the side ?

[mansijswarnkar]

Hi Nestor, thanks for this nice video. I was wondering how one could do the Percentage formula as per group in a special scenario when the column is of String values. Example % of Name/Surname/Ticket No etc display as a trend? Any idea/suggestion would be a great help. Thanks

[renopar]

In question 2, why are you including the column product?

[analyticsadda]

Hi Thanks for this. Need a DAX as per the below screenshot
Name class Section Marks %age
Dinesh X A 90. 90/90
Guru. IX. B. 50. 50/90
Hema. VII. C. 40. 40/90