DAX Union creating duplicates

Anonymous · ‎07-26-2023

I have 2 tables of the same columns and column names. Individually, they have distinct values for a certain ID column.

When I join the 2 tables via

UNION(EqmtDT, EqmtDT_H)

, the ID column now shows no distinct values. Why did this happen?

Anonymous · ‎07-26-2023

I figured out my problem. I did have dupes in the separate tables.

pceglie · ‎07-26-2023

Hi, can you share pbix file?

--

PC

DataVitalizer · ‎07-26-2023

Hi @Anonymous

Your tables might have IDs in commun thats why the distinct count of IDs does not eq to total rows.

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

Anonymous · ‎07-26-2023

There are none in common, I exported to excel and checked for duplicates and there were none.

DataVitalizer · ‎07-26-2023

Could you share the pbix file?

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

Helpful resources