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 column now shows no distinct values.  Why did this happen?

 

 

 

Need Help

5 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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