create if condition based on three columns in different tables

Hi, Anonymous 

Please check the below picture and the sample pbix file's link down below.

Status Measure =
IF (
ISFILTERED ( IDs[id] ),
IF (
MAX ( Table1[hasE?] ) = 1
|| MAX ( Table2[hasK?] ) = 1
|| MAX ( Table3[id] ) = 1,
"True",
"False"
)
)

https://www.dropbox.com/s/ab5hnvsba4315nh/fatimah.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Hi, Anonymous 

I am not sure how your desired output looks like. Please check the link down below, otherwise, please share how your expected output looks like.

https://www.dropbox.com/s/ab5hnvsba4315nh/fatimah.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM