Expanded Table - The Whiteboard #04
ฝัง
- เผยแพร่เมื่อ 28 ก.ย. 2024
- What is an expanded table in DAX? Seeing it is better than a simple description!
Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: www.sqlbi.com/...
#thewhiteboard
Marco - Thank you so much for starting these whiteboard tutorials. The experience is wonderful and not as jarring as switching screens continuously during a regular tutorial. Please keep this new set up as there is so many topics can benefit greatly from this new whiteboard approach.
Marco, Alberto, i'm from Algeria. Thank you so much with your videos i came to the point to understand the key concepts of Dax:
-evaluation context
-calculate/calcuatetable
-iterators
-context transition
-expanded tabels
Thank you so much for the insights in your videos. Using the great Dax Studio 3.0 was interesting to see the performance differences in the second example.
Red Sales =
CALCULATE (
[Sales Amount],
Product[Color] = "Red"
)
only took 1 SE Query.
Red Sales =
CALCULATE (
[Sales],
FILTER (
Sales,
RELATED ( Product[Color] ) = "Red"
)
took 3 SE Queries.
Truly grateful for the tools and videos to be able to develop understanding and do this type of analysis.
your performance test and conclusive point here is the icing on the cake (Marco's video)
Thank you so much for the incredible information you’ve shared with the world! I’ve learned so much from your videos.
Amazing, Marco!!!!!
The by far best way to learn all of this and much more is to read Marco's and Alberto's book: The Definitive Guide to DAX. There's no other book like this one. If somebody is serious about DAX, it's a must-read. Nothing's gonna give you more info on the language and its intricacies.
good stuff
Thank you for the video. I was just wondering, how is it possible to create more rows by following a 1-N relation (in the example provided the sales table "has all the rows")? Another thing, you have noted to always "filter columns not tables" - but the filter function (used in the examples) works only on tables.
I dont think you use white board effectively because it is not understandable
i was wondering what is the most efficient way to write the "Red Sales" measure.
As Marco mentioned filter columns, not tables! So I think the best approach would be to write Product[Color] = “Red” as the filter argument in the CALCULATE expression, correct me if I’m wrong.
I wish someone could explain CACLULATE steps in such way. This is in a book but the explanation is really not so easy to understand. Understanding calculate is key concept but there are so many interpretation to these steps.
Great sharing of DAX critical concept! Thanks a million!
This is Amzing contents where i get most enhanced dax knowledge!! thank you marco!
Muito bom !
One of the best expansions I’ve seen so far on the topic!!
Thank you for your work 👍
Looking forward to see the episode about relationships in DAX if there will be one!
Perfectly explained!!! Whitevoars ie great