Introduction
In DAX, lineage is an important concept, and it is vital to understand how to work with and manipulate it.
As I did in past articles, I will use DAX queries to explain this concept and its effects.
I start with a simple query to get the order count for the product of the brand “Adventure Works”:
EVALUATE CALCULATETABLE( SUMMARIZECOLUMNS('Date'[Year] ,'Date'[MonthShortName] ,'Date'[MonthKey] ,'Product'[ProductCategoryName] ,"Order Count", [Online Order Count] ) ,'Product'[BrandName] = "Adventure Works" ) ORDER BY 'Date'[MonthKey] ,'Product'[ProductCategoryName]
This is an extract of the result from the query:
Figure 1 – Result of the base query (Figure by the Author)
This query returns 180 rows.…