create if condition based on three columns in different tables

[Anonymous]

I have this 3 tables 

table1:

id	hasE?
1	1
2	1
5	0
6	0
8	1
9	1

table2:

id	hasK?
1	1
2	1
5	0
6	0
8	0
9	0

table3:

id	hasU?
1	0
2	0
5	0
6	0
8	1
9	1

and the tables has id to make relations between them

I want to create if condation in dax to compare between this three columns (hasE?,hasK?,hasU?) if one of them has 1 return true else false 

here is how i imagine it:

Status = IF('table1'[hasE?]=1 || 'table2'[hasK?]=1 || 'table3'[hasU?]=1 ,"true​","false")

[Jihwan_Kim · Accepted solution]

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

[Jihwan_Kim · Accepted solution]

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

[Anonymous]

thank you but it there any way to use the measure with slicer visual?

[Jihwan_Kim · Accepted solution]

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

[Anonymous]

yes as I need thank you so much

[amitchandak]

@Anonymous , You can not do it like this.

Either you have to create a common is a table and join all with those and create a column there.

How to do that - https://www.seerinteractive.com/blog/join-many-many-power-bi/

There 4 ways refer data of me table into another tbale

https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8