topic IFERROR Problem in DAX Commands and Tips

IFERROR Problem

Anonymous — Wed, 26 Apr 2023 11:37:59 GMT

Formula is very simple it is a sum of variables and then multiplies by a ratio

I have this meausure to compute Total Rev. I am using the IFERROR to counter NAN problem in the calculation. However if I drag and drop another column from another table it gives me an error " Visual Exceeded the available resources." IF I REMOVE THE IFERROR calculation than I don't get this error.

Total_Rev2 = ((SUM('1.Orders (fact)'[CHARGES])+SUM('1.Orders (fact)'[XCHARGES])-sum('1.Orders (fact)'[FSC_CHARGES]))* IFERROR(SUM('1.Orders (fact)'[FUNCTIONAL_AMT])/SUM('1.Orders (fact)'[TOTAL_CHARGES]),0)+(SUM('1.Order Interliner'[AMOUNT])))

Re: IFERROR Problem

lbendlin — Fri, 28 Apr 2023 02:18:17 GMT

instead of IFERROR use DIVIDE - it handles these scenarios gracefully.

Re: IFERROR Problem

Anonymous — Fri, 28 Apr 2023 02:33:23 GMT

Hi Anonymous ,

Plesae try this measure.

Total_Rev2 = ( ( SUM ( '1.Orders (fact)'[CHARGES] ) + SUM ( '1.Orders (fact)'[XCHARGES] ) - SUM ( '1.Orders (fact)'[FSC_CHARGES] ) ) * IF ( AND ( SUM ( '1.Orders (fact)'[FUNCTIONAL_AMT] ) = 0, SUM ( '1.Orders (fact)'[TOTAL_CHARGES] ) = 0 ), 0, DIVIDE ( SUM ( '1.Orders (fact)'[FUNCTIONAL_AMT] ), SUM ( '1.Orders (fact)'[TOTAL_CHARGES] ) ) ) + ( SUM ( '1 Order Interliner'[AMOUNT] ) ) )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: IFERROR Problem

Anonymous — Fri, 28 Apr 2023 11:57:01 GMT

Yes i figured it on my own as well after only an hour after posting the problem. Divide works great for this problem.