Introducing CALCULATE in DAX

This video introduces CALCULATE, the most powerful and complex function in DAX.
Article and download: sql.bi/749147?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@mathsexperts4901]

This is the best KZbin 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

[@snakeeyesOFFICIAL76]

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

[@jjpp1970]

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

[@aslakjonhaugen3004]

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! 🙂

[@mikeycbd]

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

[@unboxingcategory3353]

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

[@augustotanaka]

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

[@sandeepbarge4699]

Thanks for the series once again! Great video!

[@wigf173]

Excellent video, as always! This series is great.

[@giorgikvatchadze4928]

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

[@gborka]

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

[@evedickson2496]

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 😊😊

[@felixosagie7130]

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

[@kostaskolotouros4345]

Another great video! Thank you so much!

[@reportingmitpowerbi]

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 :)

[@vietndk5437]

Thanks for the vid, Albert. Have a nice day

[@1yyymmmddd]

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

[@MrMalorian]

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 :)

[@flyingdutchman9804]

Fantastic, thanks for sharing!

[@Bremerhaven_Rocks]

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

[@Anihe]

God how I love this channel ❤

[@edwardwernich9259]

Great video, thank you!

[@beatrenger]

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

[@willwildwest31]

Loved it!!

[@MrXmaciek]

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

[@isidrebague3659]

As allways, Great! thanks you!

[@amarnadhgunakala2901]

Its most useful ,thanks

[@nguyenanao4078]

Great! Thank you

[@phupt132]

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.

[@pbihari0214]

Thank you

[@user-lm5wb8vi1x]

Finished watching

[@karannchew2534]

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

[@karannchew2534]

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

[@kananparmar9656]

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.

[@mwaltercpa]

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.

[@SQLBI]

It's hard to say - but a page filter in Power BI is just a column filter. Hard to say without a deeper analysis.

[@meilstone]

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

[@hage131]

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

[@SQLBI]

Follow the link in the video description

[@robertkiermasz4513]

good movie :)

[@ssss54]

@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.

[@maxpayne6317]

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

[@asrahussain8642]

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

[@tombennett7317]

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?

[@SQLBI]

Every time intelligence function returns a table, and every filter is a table. See this: dax.guide/previousday/

[@tombennett7317]

@@SQLBI thank you for the response. I did check that out but it only confused me further. I'm struggling to understand how a table returned by a filter (especially a single column table) tells the calculate function what to do. In this instance the filter is just a row of dates, how does calculate know how to use and apply those dates?

[@SQLBI]

You should get a complete explanation of the filter context. A filter is always a table in the filter context. Start with the free Introducing DAX video course www.sqlbi.com/p/introducing-dax-video-course/, or read other content about the filter context: www.sqlbi.com/articles/filter-context-in-dax/

[@qasimjan5258]

Are you going to do a series on Calculate?

[@SQLBI]

We already have a full training for that! Look at the free Introducing DAX training and the path to learn DAX at www.sqlbi.com/guides/dax/

[@Milhouse77BS]

Yea🎉

[@bobkiggundu9010]

Incredibly helpful lesson to understand the fundamentals of Calculate function

[@workstuff5253]

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.

[@SQLBI]

See these articles/videos: www.sqlbi.com/articles/filter-arguments-in-calculate/ www.sqlbi.com/articles/specifying-multiple-filter-conditions-in-calculate/

[@user-bk8db7ud6k]

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

[@user-ui2wu6mm9l]

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

[@Charlie888]