Completed
) Power BI Example of “Double Count” Problem with Context Transition. Be Careful of Context Transition & "Double Count" Problem. Solutions #1: Use Formula rather than Measure.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Summary of what we know so far in class about Iterators and Table Functions
- 3 ) Summary of what we will learn in this video about Iterators and Table Functions
- 4 ) What does DAX stand for? Data Analysis eXpressions
- 5 ) Introduction to Iterator Functions
- 6 ) Learn how Iterators Work using SUMX & AVERAGEX Iterating Over Fact Table at Transaction Grain
- 7 ) Be Careful of Context Transition & Iterating over a Fact Table that "Materialize" Unnecessary Tables.
- 8 ) DAX Studio to Time DAX Formulas. Including how to use the ROW DAX Function to help time Measures.
- 9 ) Create PivotTable with Measures and see that the Measure that has to materialize a Fact Table for each row in the iteration takes a LONG time to calculate in a PivotTable.
- 10 ) Power BI Example of “Double Count” Problem with Context Transition. Be Careful of Context Transition & "Double Count" Problem. Solutions #1: Use Formula rather than Measure.
- 11 ) Solution #2: Use Power Query to add Primary Key can fix the problem also.
- 12 ) AVERAGEX at Day Grain use dDate Table. We want Context Transition in this formula and we will Never have the “Double Count” problem because dDate Table has no duplicates.
- 13 ) Grain of Fact Table or Iterator.
- 14 ) AVERAGEX at Month Grain with VALUES(Column)
- 15 ) Introduction to idea that we need DAX Table functions like VALUES to help create the correct Grain for Tables that we can use in Iterator Functions.
- 16 ) VALUES DAX Function
- 17 ) DAX Studio to Visualize or Materialize Tables
- 18 ) CROSSJOIN DAX Function.
- 19 ) CONCATENATEX and VALUES to list values in the Current Filter Context
- 20 ) AVERAGEX at Month Grain with CROSSJOIN(VALUES(Column),VALUES(Column))
- 21 ) Can we reduce "Cardinality"? Try not to Iterate over Fact Table. Alternative Formula for Total Revenue in Power BI Example. Timing formulas in DAX Studio.
- 22 ) Time DAX Measures from Power BI with DAX Studio.
- 23 ) Closer look at ALL and VALUES DAX Functions. Discuss the Blank Row that shows up from unmatched item in a relationship.
- 24 ) Compare and Contrast ALL and VALUES.
- 25 ) DISTINCT and ALLNOBLANKROW DAX Functions.
- 26 ) Look at other DAX Table Functions.
- 27 ) Discussion of FILTER DAX Table Function and CALCULATETABLE DAX Table Function
- 28 ) Look at ADDCOLUMNS DAX Function.
- 29 ) Excel Existing Connections to pull data from Data Model into Excel Sheet.
- 30 ) DAX VALUES Function to pull a variable from an Excel Sheet into the Data Model.
- 31 ) Summary
