Forum Discussion
DAX count unique values after union
Hi everybody, I am trying to create measure counting unique values of particular column, which is the result of UNION of two columns with similar data from two diffrent tables. It looks much easier ...
Hey, I had the same problem before but I got the solution. Use this measure, it's simple and works fine:
Measure= COUNTROWS(DISTINCT(UNION(VALUES(Table1[sales_manager]),VALUES(Table2[manager))))