Introducing ALLSELECTED in DAX

Introduction to ALLSELECTED, which is an extremely complex function to use in DAX.
Article and download: sql.bi/760153?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@GaryThomann-CoGC]

1:02 "the risk of doing that is that the numbers will be inaccurate, wrong, crazy, stupidly crazy, nearly impossible to understand" got that loud and clear Alberto 😆

[@CJ-jc8tn]

Having completed the wonderful 'Mastering DAX' course last year, I'm still amazed at how much extra I am learning with these high quality learning tutorials. Thank you Alberto for such a clear explanation of a tricky topic in DAX.

[@NoShadowOfDoubt1]

Allselected in that table is brilliant!

[@kwame176]

I love your course. On my way to be a power bi consultant. 🙏🏾

[@vaibhavshaktideo6930]

Great way to respect filters coming from outside the visual while still using ALL....

[@sachin.tandon]

This is really insightful Alberto! Thanks for preparing such a great tutorial!

[@arbazahmad7177]

Thanks 😊 for this great 👍 tutorial. Easy to understand.

[@cemtekesin9033]

Excellent tutorial. Thank you very much!

[@sentidocomun3096]

Very well explained, thanks Alberto.

[@juanpaduann]

This is just great!

[@dhanicole]

This is great-thanks!

[@johnlorenc9515]

Very helpful video. Thank you.

[@Bharath_PBI]

Thank you 👍

[@TiagrajI]

Thank you.

[@lindabond9307]

Great powerful tip! Is it wrong to call the examples dynamic visualised calculations? In that they respond/change with slicers/selections? Thanks again for accessible tips

[@pbihari0214]

Thank you

[@Lotaristo]

Thanks for the video. Can you please tell how do you select the whole word (like on 9:36). Is is some hotkeys combinations?

[@albertoferrari6893]

It is just shift-ctrl and the arrows, nothing fancy!

[@nabirahimov1316]

can someone explain why he multiplied Step with 1 and 2 for low and medium class? And what ALLSELECTED did in last example?

[@workstuff5253]

Random question - what make/model keyboard are you using?

[@SQLBI]

See www.sqlbi.com/blog/alberto/2021/02/14/on-my-recording-gear/

[@sbn4862]

Can I learn better these contexts and other concepts If get access to MASTERING DAX?

[@SQLBI]

Mastering DAX covers all the aspects of the language, including more advanced insights about ALLSELECTED.
However, for a good DAX learning path, follow directions described here: www.sqlbi.com/guides/dax/

[@yeyoremix]

I will steal your way of explaining when something is just not worthy to understand!
Could the risks of ALLSELECTED be avoided using VALUES instead?

[@cesarsaldana3429]

Mr. Ferrari, I read if the explanation is very tricky, in your SQLBI article, it gives the impression that he does not know exactly what the function does and he only dedicated himself to filling pages that all they do is generate more confusion on the subject.
I'm sorry but you don't understand it, read it yourself and you'll agree with me, hopefully you'll reconsider and write again in more detail.