DAX for checking if ID is same

[Sohan]

I have two tables: FactAppointment and FactSales. These tables have true/false columns FactAppointment[NewPatient] and FactSales[FirstSale]. Both tables also contain the column "UserID".

I want a calculated column in FactSales which states:
IF FactAppointment[NewPatient] = TRUE AND FactSales[FirstSale] = TRUE AND UserID is the same, then TRUE, else FALSE.

How can I write this?

[Tahreem24]

@Sohan Try something like below as per your columns and table names

 = IF(FactAppointment[NewPatient]= TRUE AND FactSales[FirstSale] = TRUE AND FactAppointment[UserID]  = FactSales[User ID], True(),False())

[Sohan]

It says the syntaxis is incorrect. I suspect because there's no direct relation between FactAppointment and FactSales.

[JorgePinho]

Hello @Sohan !

Are the tables connected? 

[Sohan]

Yes, indirectly through other tables.