Elements of DAX 05-01: Derive Iterate Application - PT

In this video, Brian Grant takes all of the knowledge you've learned thus far so you can actually start writing DAX in Power BI. You’ll start with simple aggregations—but when you write these now, you’ll be able to visualize what's happening under the hood to produce the numbers you want.

------------
Don't forget to subscribe to our channel for the latest Power BI, Power Platform, Azure, and Data Analytics content.

At CSG Pro, we love learning and sharing new technologies, processes, and solutions to help you be victorious in your role.

Work with us:

Visit our blog:

[ranaasad]

you are the best at explaining and teaching DAX. Thank you!

[joanneosborne]

Brian, I keep coming back to all your videos because, in my opinion, you are the best at explaining and teaching DAX. Thank you! 😃

[retamapark]

I have found this series very interesting. It led me to play with DAX Studio, guided by a blog by Matt Allington. I connected the table used in this series to DAX Studio, and worked through the example in the videos. Very helpful. For example,

EVALUATE
// replicate initial filter context coming from visual; Mini[Shift] = "Dinner"
VAR vInitalFilterContext =
FILTER (
ALL ( Mini ),
Mini[Shift] = "Dinner"
)
RETURN
ROW (
// ROW will effectively allow you to show a scaler value as a table, required as DAX Studio can only return tables.
"Units", SUMX (
vInitalFilterContext,
// use the visible rows to calculate the value of the express
Mini[Units]
)
)
Output is a column named "Units" with a value of 5.

Replicate the filter context coming from the visual (i.e Shift = "Dinner" and execute the SUMX expression on the temp table. DAX Studio provides a way to look at the rows in a derived table. The ROW function is necessary as DAX Studio only returns tables.

Great job by Brian and CSG Pro! Thank you!

[seanmen]

Good tutorial! Would be even more beneficial to provide the file or notes download.