Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Logic Woes with Lookupvalue

Hi All,   I have the following DAX that returns whether or not there is a duplicate value on the 'ODS' table:   Duplicates = IF(     ISBLANK(         LOOKUPVALUE('Active'[Name],'Active'[Name],...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Perhaps:

     

    Duplicates = 
VAR __table = FILTER('Active',Active[Name] = 'ODS'[EMPLOYEE_NAME] && 'Active'[Manager] = 'ODS'[MANAGER_NAME])
RETURN
IF(COUNTX(__table,[Name])=1,"NO","YES")
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Perhaps:

 

Duplicates = 
VAR __table = FILTER('Active',Active[Name] = 'ODS'[EMPLOYEE_NAME] && 'Active'[Manager] = 'ODS'[MANAGER_NAME])
RETURN
IF(COUNTX(__table,[Name])=1,"NO","YES")
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Greg_Deckler Exactly what I needed! Thanks!!!