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 table then yes otherwise no  but these two tables are in inactive mode 
and I am getting this error so how to solve this error please help me 

  • 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"
)

     

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello You missed a column in Relationship formula.

    Store the value of the relationship in a variable and compare it after

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      No, I didn't miss anything 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity 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
        Icon for Community Champion rankCommunity 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?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity 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"
)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Sorry, for which question you have answered this?