GENERATE Function (DAX)
How does the GENERATE function (DAX) work?
It returns a table with the Cartesian product between each row in table 1 and the table resulting from the assessment of table 2 in the context of the current row from table 1.
GENERATE Formula Syntax
GENERATE(<table1>, <table2>)
How do you use the GENERATE function?
All column names from table1 and table2 must be different or an error is returned.
Related Blog Posts
Related Support Forum Posts
Advanced Table Functions: GENERATE
Less Commonly Used Advanced Table Functions
Summarize not showing all data
Considerations when using the GENERATE function
If the evaluation of table2 for the current row in table1 returns an empty table, then the result table will not contain the current row from table1. This is different than GENERATEALL() where the current row from table1 will be included in the results and columns corresponding to table2 will have null values for that row.
Related Video Tutorials
Formula examples using the GENERATE function
GENERATE(
SUMMARIZE(SalesTerritory, SalesTerritory[SalesTerritoryGroup])
,SUMMARIZE(ProductCategory
, [ProductCategoryName]
, "Reseller Sales", SUMX(RELATEDTABLE(ResellerSales_USD), ResellerSales_USD[SalesAmount_USD])
)
)