Computing totals by summing visible values in DAX 

An absolute beast. SQLBI is really the best page out there for DAX. The fact this video was made 3 years ago is also insane. Congrats!

I was struggling for 3 days with this and it took me 2 mins after watching this to get what I needed. Thanks!!!

This is probably one of the most usefull tutorial i've ever seen in my entire life, trully

Thank you for this, it solved my problem ! It feels like magic when everything adds up properly. Thanks again.

Excellent. Thank you Alberto and Marco for posting these videos

This is a life saver video.... Been having a problem with a particular report for days and this just saved me!!!!!!

You saved me hours of trials. I'm happy that I found this video.

I wasted a lot of time trying with summarize and then I found this video, just amazing

One of the best. Was struggling for couple of days. Thanks a lot.

That is exactly what i needed . Thanks Alberto.

Great video! Helped me a lot. Thank you!

Thank you so much for the short video... This really helped me to solve my problem

Great elegant solution to my current issue 👍 Love you guys

Exactly what I was looking for! Thanks for sharing

This video is life saving! Thank you so much

Thanks for the video. I wish I could find this video before 3 days of suffering🙂

Ciao Alberto, huge fan of your work here!...I think the video is repeated in the playlist.

Thank you! I was able to figure it out because of this explanation 🎉

You saved my day! Thank you so much!

Grazie Maestros!!! Grazie per Tutti !!

Thank you so much for sharing. you are awesome

Salved my life! Thanks a lot!

Hi Alberto, in the final expression around the 3:43 mark why is the outer CALCULATE necessary? Both the Sales Amount measure and the COUNTROWS expression are already embedded within one, so the context transition from the SUMX iterator will happen anyway.

Hi, I feel like the first CALCULATE is not useful here since the context transition is already there (use measure + other CALCULATE). What do you think of this code: COUNTROWS(FILTER('Date', 'Date'[Working Day]="Workday" && [Sales Amount])). Thanks

Thanks its helpful

Super, it would be helpful if you show how sort the columns based on the grand total in the bottom. Eg: left coulum with customer name, top columns are with few sales rep names and in the table it will have each sales reps sales amount for each customer, now i want to sort the sale rep based on the total sales done by each rep( total in the bottom)

What would the PBI developers be without SQLBI. THANKS A LOOOTT!!!

Great video! It really helped me out. However I'm struggling to make it work when trying to iterate on more then one column by using summarize columns. Any tips how to make it work as if in the example placing the year and month in separate columns?

I already knew this calculation, but sometimes I like to review some calculations and I always come to the conclusion that many courses are inspired by your material. It is the path to immortality. I'm just sorry that the number of "LIKES" doesn't reflect the number of views. It is the least we can do to acknowledge the excellent work that Alberto and Marco have been doing for years and that many people have helped. How difficult can it be to make "LIKE" ???

Do you have other videos similar to this, im stuck on a similar'ish problem. I am trying to average a division at the total level but its not working.

Hello Sir! This was insightful Thankyou! I however am facing an issue if anyone can help. You see, I have one Measure(Hrs Above Base) where I simply calculate difference between two other measures of the same table (Actual). Now, when the result of difference is negative I want to set it to zero. It is doing exactly this But then the Total seems to be incorrect still. I am iterating on the resources here. Am I missing anything here ?

Is there a way to do the following I created a measure to get proportion of sale per entity divided by the total sales across all entities. Then I wanted to create a measure called other that groups all entity sales that are below 3% into one summed up value. using alteryx what you can do is just a formula tool that can write new column called comment and get it to comment other in row if below 2% total sales and then just filter out comment other and sum it to get a one value called other. I was just trying to figure out how to sum of a measure that is not based on values in a table but also another measure? If i can create a calculated column that just pulls in the values when its below 3% I can just sum the column in that table. But as its a measure I cannot use a sum or sumx. I tried to get the measure into a calculated column but it won't let me because the rows have different values and it needs to be one.

Nice 👍

For all those people arriving from excel environment I wish you good luck a lot of petience :)

I am still waiting the day when I have fun with DAX...

Nice - if you can have sales value of both positive and negative, I would presume your if condition instead of >0 would isnotblank ?

Hello Is the standard SUMMARIZE or ADDCOLUMNS + SUMMARIZE technique equivalent?

How do you zoom in and out in Power BI?

but if ever we want to show this table say by weeks, not by months, we should create another measure?

Having a date table with the min and max date of the sales table would have prevented this error. Though I learnt something new.

Hello This formula does not work When you want to average visible values

But then your measure will only give the correct subtotals for the field defined in DAX VALUE() {Calendar Year Month} If we pull some other columns lets say Department level we will get incorrect totals. Whats your take on this?

Ahhhhhh...... Why does this work? I plagiarized the code. It corrected a similar problem I was having. Pax LY = SUMX ( VALUES ( '_Calendar'[Date] ), CALCULATE ( IF ( ISBLANK ( [Pax] ), BLANK (), CALCULATE ( [Pax], SAMEPERIODLASTYEAR ( _Calendar[Date] ) ) ) ) )

Best way is to use a Power Query generated Index column for the Values function

Thanks a lot! Problem solved!