topic Re: Getting distinct values for multiple tables in DAX Commands and Tips

Getting distinct values for multiple tables

Morgana_2022 — Mon, 16 Jan 2023 19:57:29 GMT

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!

Re: Getting distinct values for multiple tables

tamerj1 — Mon, 16 Jan 2023 19:30:34 GMT

Hi Morgana_2022

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

Re: Getting distinct values for multiple tables

Morgana_2022 — Mon, 16 Jan 2023 19:59:44 GMT

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?

Re: Getting distinct values for multiple tables

tamerj1 — Tue, 17 Jan 2023 02:23:11 GMT

Morgana_2022

Simply

Table C =

UNION (

VALUES ( 'Table A'[Competenze_Ruoli] ),

VALUES ( 'Table B'[Competenze_Ruoli] )

)

Re: Getting distinct values for multiple tables

Morgana_2022 — Tue, 17 Jan 2023 07:18:32 GMT

tamerj1
thanks, it works!

Re: Getting distinct values for multiple tables

Morgana_2022 — Wed, 18 Jan 2023 12:57:10 GMT

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

)

Re: Getting distinct values for multiple tables

tamerj1 — Wed, 18 Jan 2023 13:18:01 GMT

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

Re: Getting distinct values for multiple tables

Morgana_2022 — Wed, 18 Jan 2023 15:59:42 GMT

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

Re: Getting distinct values for multiple tables

tamerj1 — Wed, 18 Jan 2023 16:53:26 GMT

Morgana_2022

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