Introducing CALCULATE in DAX 

This is the best RU-vid channel for learning DAX, I am learning so much from these videos. This channel really deserves to have more subscribers. I would love to purchase their DAX courses, but unfortunately prices are higher than my current income. I am following all of their youtube videos and free courses

this videos and channel deserve many more subscribers and views that they have... it is a hidden treasure

Alberto, You are an expert in Dax and an expert in teaching. Congratulations for those strengths. Thank you for your great explanations.

I wish this video existed some years ago when I tried to learn Dax! Fantastic way of describing the Calculate function! More videos of this type! 🙂

Wow, these are some of the most crucial lessons to learn. Thank you from Melbourne Au.

you are amazing, Iam a data analyst in Egypt, following you and your website, thanks for this amazing work DAX programming language is coming

This 101 series is lovely! Thanks for all the knowledge!

Thanks for the series once again! Great video!

Excellent video, as always! This series is great.

Brilliant video as always... even when I think I know the subject being shown, there is always a golden nugget I can learn and then use in work 😊😊

I find your videos very insightful, easy-to-follow and useful!

Thank you for sharing, really great idea to build the understanding layer by layer: *Row Context *Filter Context *CALCULATE Function *Context Transition

Thank you so much Albert. This is very explicit and insightful. Much appreciates

Yup, this is exactly what I keep messing up. The idea that the calculation overrides the visual filter is hard to get my head around. I just need to keep watching this video when it happens :)

Another great video! Thank you so much!

Great and precise video (as always), really helpful for my job as Power BI Trainer/Consultant...Keep up the good work, thank you so much, mille grazie :)

Thanks for the vid, Albert. Have a nice day

Fantastic, thanks for sharing!

Great video, thank you!

God how I love this channel ❤

Thank you. Can't wait for the Context Transition video =)

Loved it!!

good job. i like the way how you are explaining things

Thank you for another great video. Never considered that FILTER (Products, ...) filters entire expanded table.

As allways, Great! thanks you!

Fantastic Content! Very cool. It has helped me a lot!!

Its most useful ,thanks

Great! Thank you

Thank you

Finished watching

Hi Alberto, many thanks for these very hepful videos. Just a quick question for newbies as follows: At 5:55. Red Sales overwrote the outer filter context which is by Color (all the rows are with values 382,601) but why the filter context by Brand, it doesn't overwrite as we can see Red sales by across different brands.

10:28 People try different combination until one that works. That's me! But hopefully not any more!

Hi @Alberto Ferrari sir what dax we should make so that it can give us the break-up sale value for both if we take Brand or Color in single table view.

How do you access values of a column in an unrelated table 'Y' when defining a new measure in table 'X'?

Notes for future revision. Why / when use CALCULATE()? 1. Change filter context. 2. Enbale context transition.

Great video! Can I found somewhere the sample pbix used for the tutorials?

Appreciate this video and the reminder to use KEEPFILTERS() over FILTER(Table). Question Alberto, if my entire page requires only calculations on the same customer subset, is writing KEEPFILTERS in each of my DAX measure more performant than using a single page filter over the whole report page? I ran into slow performance using a page filter… I rebooted, installed a new version of desktop, wrote my filters in calculate, and it performed much faster.

7:15 But here the calculate filter doesnt override the outer filter context right? Its combined together from my understanding.

@SQLBI at time 11:18 if we woulf have had ALL(Product), Product[Color] = "Red" then the outcome would have been different. Can you please elaborate the difference between the two please.

good movie :)

Great video. Can you explain how PREVIOUSDAY works as a CALCULATE filter? The documentation says it just returns a single column table of dates so why does that work as a filter?

he's the most italian person i've ever seen

Are you going to do a series on Calculate?

As someone learning DAX, if I were to be explicit, and write the full FILTER instead of the shortened predicate, do you know if performance would be the same? EDIT: Also, you mention "Never filter a table - only the columns you need". What is the correct way to filter columns when ALL isn't an option as VALUES only accepts a single columns. Thanks for the great video.

Yea🎉

In this case, Ferrari is not second to Red Bull...

Всё это, конечно, очень интересно... Только было бы гораздо понятнее на русском языке )))