Understanding CALCULATE in DAX: Percentage of Total 

I’ve looked everywhere on the internet to find a solid way to calculate the percentage of total row, and this is exactly what I was looking for. Thank you for the well explained video!

This is beyond helpful. Was totally struggling on the Dax syntax for this. Super greatful. Especially for the part where the column will change for a new or 2nd pivot.

Brilliant video, thank you so much. By far the best explaination of this I've seen. Thank you for taking the time to make and share.

finallyy man.. i been at work all day trying to find an example of calculating a weighted average... your a lifesaver and earned yourself a new subscriber!! 100%

Thank you so very much! I spent all day yesterday trying to get this exact work done. I'm grateful

This was exactly what I was searching for. Thank you!

great explanation , 4 days searching for this solution, Many Thanks ❤❤👌👌

Thank you. Exactly what I have been looking for. To calculate the % of subtotals.

This is fantastic, gold star for me when I use this in my report. Many thanks

very helpful. Thank you.

Perfectly explained

Nicely explained!

You are the best☺️👍

Hi there wonderful video thank you so much! Quick question, what application do you use to Box (red) around a certain area while demo'ing something? I have Zoomit, which is helpful with Zooming but not very easy to get to a box.

This is a great tutorial to create total percentages in DAX. I have one question I'd would like your help. Let's say I am creating a matrix visual about some population distribution across states. I also break down the states' distribution by demographics such as age group, gender, race group (in the matrix, state is the row field, and gender, or age group, or race are the columns). To show the row percentages for different categories of age group, gender, or race group, I would like to create a DAX measure; the row total disregarding gender should be: VAR population_rowtotal= CALCULATE( [# population], REMOVEFILTERS(pop_final[gender] ) ) I can calculate the row percentages as DIVIDE([# population], [population_rowtotal]). This DAX measure is for row percentages for gender only. I can also create DAX measures for row percentages of race, or age group. But I would like to use a parameter including gender, race, age groups, as the column in the matrix. So the matrix will be dynamic based on the column field I select. That means the Dax measure of row total / percentage should also be dynamic based on the selected column field. How can I achieve this in the DAX measure statement: REMOVEFILTERS(pop_final[gender] or [racegroup] or [agegroup]). Thanks.

Very useful video

Hi Rick, this is really good and helpful. I had a question. What if I want my row total to be treated as 100% and then each cell of that row reflects the % contribution leading to the row total. Is this possible. How will the DAX work in this scenario. Any help or idea is appreciated. Thanks a lot. Regards.

Nice presented.

Heel gaaf. Bedankt

Hi, well I'm an 'All ' person, simply because I can use it in Bi or PP. My question is this, if removing all filter to create the denominator, i've used CALCULATE( [Total sales], All(CALENDAR ) , ALL(Sales Table) ) , as I don't always know what I'm going to be dropping in to the visual, usually matrix, I can't help feeling there should be a better approach, I've tried using summarize and crossjoin, any suggestions on removing filters from multiple tables

What is the difference between "Return variable name" and "Return Result"? Thank you!

Hi Sir, facing an issue need your help for the mentioned below I have a Project with 3 Location columns and 1 value columns (WTG = 100% sum of all location activities) in power Bi. I want to see percentage in the Card visual chart and it should be link with locations. means when I select location or its sub location so it show me cumulative percentage of that selected location only calculating it as 100%. Construction = 100% Pipeline = 45% Wellheads = 30% Processing Plant = 25% I want like this if i select construction the Card visual show me percentage from 100% and when i select its sub-phases e.g. pipeline then it should not show me 45%; it should show me 100% so that i can change the date and calculate the variance in one visual.

Hi Gorilla, Great thanks for this Clips. It is very informative. I had one query, whether the figures will get change as per filter selection. Thanks in Advance

Hi, a question, you didnt show how the [ sales ] measure was created, do you mind explaining?

I’m trying to use this video to calculate the percentage of subtotals - so to use the data from your example 4 is 13% of 31 (the total for regular).

😊

what happened if we need the share of the productos? I mean that the sum of % products to be 100% for example: Class deluxe: 16% A.Datum Super :57% A.Datum Constumer: 43%

great video..can we follow similar process when calculating margin% yearly

Hi Hope you are doing I like your way of explanation for every topic very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used while we can do practice on same data either you can provide us pbix file. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

If i need % for product name from class name and class name from grand total ??????

5:44 Je deelt toch niet door nul? Je deelt dan nul door 31 en dat geeft weer nul en wordt dan niet getoond.

I’ve looked everywhere on the internet to find a solid way to calculate the percentage of total row, and this is exactly what I was looking for. Thank you for the well explained video!