Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Union creating duplicates

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 colum...
Need Help
DataVitalizer's avatar
DataVitalizer
Super User
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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

  • DataVitalizer's avatar
    DataVitalizer
    Super User
    3 years ago

    Could you share the pbix file?


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