Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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")
Solved! Go to 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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
thank you but it there any way to use the measure with slicer visual?
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
yes as I need thank you so much
@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
User | Count |
---|---|
20 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
29 | |
28 | |
13 | |
12 | |
11 |