The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
13 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |