Getting distinct values for multiple tables

[Morgana_2022]

HI!

I have 2 tables: Table A and Table B.

 

I have to create a new table C with the data "Competenze_Ruoli" obtained from the distinct sum (without duplicates) of the same data present in tables A and B.

How can I do?
Thank you!

[Morgana_2022]

Hi!
if I have to add a new column in addition to this one obtained with UNION, how do I write it?

Table C =

UNION (

VALUES ( 'Table A'[Competenze_Ruoli] ),

VALUES ( 'Table B'[Competenze_Ruoli] )

)

)

[tamerj1]

@Morgana_2022 

Table C =
DISTINCT (
UNION (
SUMMARIZE ( 'Table A', 'Table A'[Competenze_Ruoli], 'Table A'[Column] ),
SUMMARIZE ( 'Table B', 'Table B'[Competenze_Ruoli], 'Table B'[Column] )
)
)

[Morgana_2022]

@tamerj1 
no, I have to add the new column outside the DISTINCT.
The DISTINCT generates one, I have to add a second one in addition to the one generated by the DISTINCT...

[tamerj1]

@Morgana_2022 

It depends from which table, if you have relationships, based on which conditions.....

[Morgana_2022]

@tamerj1 
thanks, it works!

[tamerj1]

Hi @Morgana_2022 

distinct sum of what? Can you present sample of the the expected results?

[Morgana_2022]

I try to explain better...

I have a Table A
column "Competenze_Ruoli" 
with values
1
2
2
3
1
3

I have also a Table B
column "Competenze_Ruoli" 
with values
1
1
2
3
3
2

I must obtained a Table C
column "Competenze_Ruoli" 
with values
1
2
3

How do I get the Table C? What dax formula do I use?

[tamerj1]

@Morgana_2022 

Simply

Table C =

UNION (

VALUES ( 'Table A'[Competenze_Ruoli] ),

VALUES ( 'Table B'[Competenze_Ruoli] )

)

)