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.
Hi all,
I am trying to have a multiple IF Statement where it looks for a value and then if it matches it adds the result but if it only matches the third or fourth IF Statement then it adds those values instead.
Example:
=IF(Col1 || Col2 >0, "Ans1", IF(Col3 || Col4>0, "Ans2", IF(Col5 || Col6>0, "Ans3", "Ans4))))
Desired Outcome:
Row1 where Col1 = 1 and Col5=2 result would equal "Ans1Ans3"
Row2 where Col1=0 and Col6=6 result would equal "Ans3"
Row3 where all Col=0 result would equal "Ans4"
All thoughts and help would be gretaly appreciated!
Solved! Go to Solution.
Hi @twolten,
Nope. dax not support calculation which you mentioned, you had to manually write formula/variable to calculate and return merged result .
Calculate column formula:
formula = VAR v1 = IF ( Table[Col1] + Table[Col2] > 0, "Ans1" ) VAR v2 = IF ( Table[Col3] + Table[Col4] > 0, "Ans2" ) VAR v3 = IF ( Table[Col5] + Table[Col6] > 0, "Ans3" ) VAR v4 = IF ( Table[Col1] + Table[Col2] + Table[Col3] + Table[Col4] + Table[Col5] + Table[Col6] = 0, "Ans4" ) RETURN IF ( v4 <> BLANK (), v4, v1 & v2 & v3 )
Regards,
Xiaoxin Sheng
Hi @twolten,
Nope. dax not support calculation which you mentioned, you had to manually write formula/variable to calculate and return merged result .
Calculate column formula:
formula = VAR v1 = IF ( Table[Col1] + Table[Col2] > 0, "Ans1" ) VAR v2 = IF ( Table[Col3] + Table[Col4] > 0, "Ans2" ) VAR v3 = IF ( Table[Col5] + Table[Col6] > 0, "Ans3" ) VAR v4 = IF ( Table[Col1] + Table[Col2] + Table[Col3] + Table[Col4] + Table[Col5] + Table[Col6] = 0, "Ans4" ) RETURN IF ( v4 <> BLANK (), v4, v1 & v2 & v3 )
Regards,
Xiaoxin Sheng
Thank you for this, it is really helpful!
However, I have run into another problem now. With the DAX calaculation complete I realised there is no way to parse the results of the calculation for filtering purposes.
For instance on result will have 'Ans1,Ans4' and another will have 'Ans1,Ans2,Ans3'
How can I parse these to be able to filter the results? Any ideas?
Thank you again for the help so far.
User | Count |
---|---|
128 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
193 | |
96 | |
66 | |
62 | |
52 |