Framework Flashcards
What is DAX?
Its a querying language for building Summary Tables on demand.
What is a summary table?
Its like a pivot table of your model, you take detailed rows and dax creates summary tables on the fly
What does every single power bi visual have behind it?
A summary table
What does every data point in a visual correspond to?
A specific row in a summary table
What are the 2 sections of Summary Tables?
Grouping Columns and Measure Columns
In Summary Tables, what are the Grouping Columns?
The combination of categories we want to answer questions about
In Summary Tables, what are the Measure Columns?
The answer for every combination of categories or the answer for a group
How are Summary Tables created?
By Summary Queires (DAX queries)
What are visuals in Power BI built with?
Summary Tables
What is the key to understanding DAX?
Think in tables. What does the summary table need to look like to answer your question
What are the 3 elements of the long DAX framework?
Revise, Derive, Iterate
What does the Revise element do?
Add or Remove filters
What does the Derive element do?
Derive tables, they create temp tables based on current filters
What does the Iterate element do?
Iterate through temp tables, They process temp tables into new numbers or new temp tables
Common Revisers
CALCULATE( )
CALCULATETABLE( )
[Any Measure]
What are the 7 coding patterns?
It is the common arrangment of the three long dax elements
- Builder
- Clearing Override
- Static Override
- Dynamic Override
- Per Item
- Comparison
- Safety
Common Derivations
Table
VALUES( Column )
ALL( Table )
ALL( Column )
Common Iterators
SUMX( )
AVERAGEX( )
MAXX( )/MINX( )
FILTER ( )
What is the Builder coding pattern?
Build a new value using a derivaiton, iterator and exitising filters
Explain the builder coding pattern
Modify the Filter Context, Derive a temp table, add a column to it, and iterate
What is the Clearing Override coding pattern?
Remove the same filter every time
What is the Static Override coding pattern?
Add the same filter every time
What is the Dynamic Override coding pattern?
Add a new “smart” filter every time
