This is the best UA-cam 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
Since I discovered your channel, book and videos, I am finally starting to understand dax and its subtleties. Thank you for the quality study material!
Thank you for sharing, really great idea to build the understanding layer by layer: *Row Context *Filter Context *CALCULATE Function *Context Transition
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 :)
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 :)
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.
@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.
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.
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 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?
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/
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.
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.
See these articles/videos: www.sqlbi.com/articles/filter-arguments-in-calculate/ www.sqlbi.com/articles/specifying-multiple-filter-conditions-in-calculate/
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.
This is the best UA-cam 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
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! 🙂
Since I discovered your channel, book and videos, I am finally starting to understand dax and its subtleties. Thank you for the quality study material!
you are amazing,
Iam a data analyst in Egypt,
following you and your website,
thanks for this amazing work
DAX programming language is coming
Wow, these are some of the most crucial lessons to learn. Thank you from Melbourne Au.
Thank you for sharing, really great idea to build the understanding layer by layer:
*Row Context
*Filter Context
*CALCULATE Function
*Context Transition
Thank you for another great video. Never considered that FILTER (Products, ...) filters entire expanded table.
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 😊😊
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 :)
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 :)
This 101 series is lovely! Thanks for all the knowledge!
I find your videos very insightful, easy-to-follow and useful!
Thank you so much Albert. This is very explicit and insightful. Much appreciates
Thanks for the vid, Albert. Have a nice day
Thank you. Can't wait for the Context Transition video =)
Thanks for the series once again! Great video!
God how I love this channel ❤
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.
Excellent video, as always! This series is great.
Fantastic Content! Very cool. It has helped me a lot!!
good job. i like the way how you are explaining things
Another great video! Thank you so much!
Fantastic, thanks for sharing!
@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.
Great video, thank you!
How do you access values of a column in an unrelated table 'Y' when defining a new measure in table 'X'?
7:15
But here the calculate filter doesnt override the outer filter context right?
Its combined together from my understanding.
Loved it!!
Great video! Can I found somewhere the sample pbix used for the tutorials?
Follow the link in the video description
Notes for future revision.
Why / when use CALCULATE()?
1. Change filter context.
2. Enbale context transition.
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.
As allways, Great!
thanks you!
Its most useful ,thanks
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?
Every time intelligence function returns a table, and every filter is a table.
See this: dax.guide/previousday/
@@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?
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/
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.
It's hard to say - but a page filter in Power BI is just a column filter. Hard to say without a deeper analysis.
the file already has work in it. nothing for us to do.
Are you going to do a series on Calculate?
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/
Thank you
Finished watching
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.
See these articles/videos:
www.sqlbi.com/articles/filter-arguments-in-calculate/
www.sqlbi.com/articles/specifying-multiple-filter-conditions-in-calculate/
Great! Thank you
good movie :)
he's the most italian person i've ever seen
Yea🎉
Incredibly helpful lesson to understand the fundamentals of Calculate function
In this case, Ferrari is not second to Red Bull...
boss of dax
Всё это, конечно, очень интересно... Только было бы гораздо понятнее на русском языке )))