cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Getting distinct values for multiple tables

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!

8 REPLIES 8
Helper I

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] )

)

)

Super User

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

Helper I

@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...

Super User

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

Helper I

@tamerj1
thanks, it works!

Super User

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

Helper I

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?

Super User

Simply

Table C =

UNION (

VALUES ( 'Table A'[Competenze_Ruoli] ),

VALUES ( 'Table B'[Competenze_Ruoli] )

)

)

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors