Dax Error

[Anonymous]

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 

[Anonymous]

Sorry, for which question you have answered this?

[tamerj1 · Accepted solution]

@Anonymous 
Please try

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

[Anonymous]

Hai @tamerj1  Thank you for the solution
Please check this requiremtn
https://community.powerbi.com/t5/Desktop/Converting-static-to-Dynamic-Measure/m-p/2550780

[Anonymous]

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

[tamerj1]

@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

[Anonymous]

Hai @tamerj1, am accepting this solution, and can you please help me to achieve this requirement too 
https://community.powerbi.com/t5/Desktop/Converting-static-to-Dynamic-Measure/m-p/2550780

[tamerj1]

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

[Anonymous]

Sure @tamerj1 

This is the relation with these two tables

[tamerj1]

@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]

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

[Anonymous]

Hello You missed a column in Relationship formula.

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

[Anonymous]

No, I didn't miss anything