Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have the following DAX that returns whether or not there is a duplicate value on the 'ODS' table:
Solved! Go to Solution.
Perhaps:
Duplicates = VAR __table = FILTER('Active',Active[Name] = 'ODS'[EMPLOYEE_NAME] && 'Active'[Manager] = 'ODS'[MANAGER_NAME]) RETURN IF(COUNTX(__table,[Name])=1,"NO","YES")
Perhaps:
Duplicates = VAR __table = FILTER('Active',Active[Name] = 'ODS'[EMPLOYEE_NAME] && 'Active'[Manager] = 'ODS'[MANAGER_NAME]) RETURN IF(COUNTX(__table,[Name])=1,"NO","YES")
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |