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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hai tamerj1  Yes it's working , can you explain why you used isblank here

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 
I changed my reply to ISEMPTY for more simplicity. 
You have one to many relationship between the two tables. If you want to pul values from the many side to the one side it won't be a single value for each row. Rather it would be multiple values (a table). If now values are return then this table is EMPTY or the number of its rows ISBLANK