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

Hi 
Would you please share ascreeshot of your data model with th erlationships?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sure tamerj1 

This is the relation with these two tables

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 
    Are you creating a column (calculated column) or a measure? If you are creating a calculated column then please advise in which table?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hai tamerj1 I am creating a calculated column in T1 Database table