All Distinct Values from Table1 Column1 for Each of All Distinct Values from Table2 Column2

Question

Hi,&nbsp;I have two columns in two different tables, and I want to make a new table with DAX that lists each of ALL distinct values from a column in the first table with each of ALL Distinct Values from a column in the second table.&nbsp; As a note, these two tables are not related in any way.&nbsp;Table 1&nbsp;Table 2&nbsp;Resultant Table&nbsp;Column 1&nbsp;Column 2&nbsp;Column 3Column 41&nbsp;A&nbsp;1A2&nbsp;B&nbsp;1B2&nbsp;B&nbsp;2A3&nbsp;B&nbsp;2B&nbsp;&nbsp;&nbsp;&nbsp;3A&nbsp;&nbsp;&nbsp;&nbsp;3B&nbsp;Thanks,Mo

parry2k · Accepted Answer

mmoeller&nbsp;try this to create new table
&nbsp;
New Table = 
CROSSJOIN (
VALUES ( Table1[Column1] ),
VALUES ( Table2[Column2] )
)
Would appreciate Kudos 🙂 if my solution helped.&nbsp;

Forum Discussion

All Distinct Values from Table1 Column1 for Each of All Distinct Values from Table2 Column2

1 Reply

Related content

count distinct

Distinct Count

Distinct count

DAX Calculation for Distinct Count

Distinct CountX?

Table 1	Table 2	Resultant Table
Column 1	Column 2	Column 3	Column 4
1	A	1	A
2	B	1	B
2	B	2	A
3	B	2	B
		3	A
		3	B