DAX Union creating duplicates

[Anonymous]

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]

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

[pceglie]

Hi, can you share pbix file?

--

PC

[DataVitalizer]

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]

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

[DataVitalizer]

Could you share the pbix file?

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