Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Morgana_2022
Helper I
Helper I

Getting distinct values for multiple tables

HI!

I have 2 tables: Table A and Table B.

tables.jpg

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
Morgana_2022
Helper I
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] )

)

)

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

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

@Morgana_2022 

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

Morgana_2022
Helper I
Helper I

@tamerj1 
thanks, it works!

tamerj1
Super User
Super User

Hi @Morgana_2022 

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

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?

@Morgana_2022 

Simply

Table C =

UNION (

VALUES ( 'Table A'[Competenze_Ruoli] ),

VALUES ( 'Table B'[Competenze_Ruoli] )

)

)

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.