Expanded Table - The Whiteboard #04

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

[@chikstnt]

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

[@brendali5803]

Great sharing of DAX critical concept! Thanks a million!

[@CJ-jc8tn]

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.

[@danthompson8309]

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.

[@akthar3]

your performance test and conclusive point here is the icing on the cake (Marco's video)

[@김차수-k2u]

This is Amzing contents where i get most enhanced dax knowledge!! thank you marco!

[@KevinStudent]

Thank you so much for the incredible information you’ve shared with the world! I’ve learned so much from your videos.

[@egorshiyanov1206]

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!

[@HugoVenturini]

Amazing, Marco!!!!!

[@dariuszspiewak5624]

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.

[@eson83]

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.

[@douglascory]

good stuff

[@powerbinareal]

Muito bom !

[@cupidvivi]

i was wondering what is the most efficient way to write the "Red Sales" measure.

[@manideep8566]

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.

[@ishakapoor2692]

I dont think you use white board effectively because it is not understandable

[@Wzxxx]

Perfectly explained!!! Whitevoars ie great

[@Wzxxx]

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.