Forum Discussion
create if condition based on three columns in different tables
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")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
5 Replies
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=czNHt7UXIe8Hi, 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
