topic Re: create if condition based on three columns in different tables in DAX Commands and Tips

create if condition based on three columns in different tables

Anonymous — Mon, 07 Jun 2021 11:32:44 GMT

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")

any help?

Re: create if condition based on three columns in different tables

amitchandak — Mon, 07 Jun 2021 12:19:51 GMT

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

Re: create if condition based on three columns in different tables

Jihwan_Kim — Mon, 07 Jun 2021 13:02:29 GMT

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

Re: create if condition based on three columns in different tables

Anonymous — Mon, 07 Jun 2021 14:06:27 GMT

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

Re: create if condition based on three columns in different tables

Jihwan_Kim — Mon, 07 Jun 2021 14:25:09 GMT

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

Re: create if condition based on three columns in different tables

Anonymous — Mon, 07 Jun 2021 15:13:21 GMT

yes as I need thank you so much