Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I have an IF statement with multiple conditions joined with && (AND). Some of the conditions are simple whereas others may take some time to compute.
Does DAX stops evaluation of multiple && if let's say first condition returns FALSE? Or all conditions must be evaluated first and then do the comparison?
Example:
IF ( ISBLANK([Measure]) && ISBLANK(CLACULATE([Measure], ALLSELECTED('Table1')) && HASONEVALUE('Table2'[Val1]) && MIN('Table2'[Val1]) = 'test'
, TRUE()
, FALSE()
)
Solved! Go to Solution.
@Anonymous The existence of IF.EAGER tends to indicate the former. IF.EAGER function (DAX) - DAX | Microsoft Docs
@Anonymous The existence of IF.EAGER tends to indicate the former. IF.EAGER function (DAX) - DAX | Microsoft Docs
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 16 | |
| 8 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 25 | |
| 13 | |
| 12 | |
| 10 | |
| 6 |