✖️ Cartesian Product

Goal: Generate all possible combinations.
CROSSJOIN: Returns a table where every row from Table A is paired with every row from Table B.

Colors (2 Rows)
Sizes (3 Rows)
Result: 2 x 3 = 6 Rows
Ready...

💻 DAX Formula

-- Generate all Color/Size combinations
EVALUATE Combinations =
CROSSJOIN(
Colors, -- Table 1 (2 rows)
Sizes -- Table 2 (3 rows)
)
Rows Generated:
0