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.

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.

Formula examples using the GENERATE function

GENERATE(  
 SUMMARIZE(SalesTerritory, SalesTerritory[SalesTerritoryGroup])  
 ,SUMMARIZE(ProductCategory   
 , [ProductCategoryName]  
 , "Reseller Sales", SUMX(RELATEDTABLE(ResellerSales_USD), ResellerSales_USD[SalesAmount_USD])  
 )  
 )