Это видео недоступно.
Сожалеем об этом.
Introducing CALCULATE in DAX
HTML-код
- Опубликовано: 25 апр 2022
- 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...
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!
This is the best RUclips 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.
This 101 series is lovely! Thanks for all the knowledge!
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!
Thanks for the series once again! Great video!
Excellent video, as always! This series is great.
you are amazing,
Iam a data analyst in Egypt,
following you and your website,
thanks for this amazing work
DAX programming language is coming
Thank you for sharing, really great idea to build the understanding layer by layer:
*Row Context
*Filter Context
*CALCULATE Function
*Context Transition
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 :)
Thank you so much Albert. This is very explicit and insightful. Much appreciates
Another great video! Thank you so much!
Thank you for another great video. Never considered that FILTER (Products, ...) filters entire expanded table.
Thanks for the vid, Albert. Have a nice day
Thank you. Can't wait for the Context Transition video =)
Fantastic, thanks for sharing!
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 :)
Great video, thank you!
Fantastic Content! Very cool. It has helped me a lot!!
Loved it!!
God how I love this channel ❤
good job. i like the way how you are explaining things
Its most useful ,thanks
As allways, Great!
thanks you!
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.
Notes for future revision.
Why / when use CALCULATE()?
1. Change filter context.
2. Enbale context transition.
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.
How do you access values of a column in an unrelated table 'Y' when defining a new measure in table 'X'?
Great video! Can I found somewhere the sample pbix used for the tutorials?
Follow the link in the video description
@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.
7:15
But here the calculate filter doesnt override the outer filter context right?
Its combined together from my understanding.
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/
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?
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/
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/
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...
Всё это, конечно, очень интересно... Только было бы гораздо понятнее на русском языке )))