Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax Error

Hai All, please help me to solve this error,  I am trying to create a flag, but these two tables are in an inactive relationship, The logic is if the ambassador's name is present in the t1 ta...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 
    Please try

     

    Ambassador =
IF (
    ISEMPTY (
        CALCULATETABLE (
            VALUES ( Ambassador[Ambassador Email] ),
            USERELATIONSHIP ( Ambassador[Ambassador Email], 'T1 Data Base'[User Email] )
        )
    ),
    "No",
    "Yes"
)

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 
Please try

 

Ambassador =
IF (
    ISEMPTY (
        CALCULATETABLE (
            VALUES ( Ambassador[Ambassador Email] ),
            USERELATIONSHIP ( Ambassador[Ambassador Email], 'T1 Data Base'[User Email] )
        )
    ),
    "No",
    "Yes"
)