See if ID is same in other table based on criteria

[Anonymous]

I have two tables, FactAppointment and FactSales. I want to check if the userID for the first sale is the same as the userID for the first appointment.

I already have calculated columns FactSales[FirstSale] and FactAppointment[FirstAppointment] which indicate with TRUE/FALSE if it is the first appointment/sale. 

How can I check if the userID for the first sale and appointment are the same? I created a calculated column in FactSales with the following code, but it does not deliver the desired result. 

SameUserID = 

IF(
    CALCULATE(MIN(FactAppointment[UserID]),
    ALLEXCEPT(FactAppointment, DimUser[UserID]),
    FILTER(FactAppointment, FactAppointment[FirstAppointment] = TRUE() && FactSales[FirstSale] = TRUE())) = FactSales[UserID],
    TRUE()
)

Any help is appreciated!

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523