Divide by zero error

kristel_tulio — Fri, 11 Nov 2022 00:40:01 GMT

Hi, asking for your help how to fix this. I'm getting an error "Divide by zero encountered" when loading my data. This is the calculations I think that causing the error. The calculated column is working but my whole dataset is not loading properly. Thank you

z Payments Calculated Amount = SWITCH( TRUE(),
[Line Amount Types] = "Inclusive" && [Type] = "ACCREC",
(([Line Amount]-[Tax Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Exclusive" && [Type] = "ACCREC",
(([Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "NoTax" && [Type] = "ACCREC",
(([Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Inclusive" && [Type] = "ACCPAY",
(0-([Line Amount]-[Tax Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "NoTax" || [Line Amount Types] = "NoTax" && [Type] = "ACCPAY",
((0-[Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Exclusive" || [Line Amount Types] = "NoTax" && [Type] = "ACCPAY",
((0-[Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
0)

I tried using the DIVIDE() function but still getting the same error.

Re: Divide by zero error

amitchandak — Fri, 11 Nov 2022 02:37:34 GMT

kristel_tulio , Remove this column and check, this may be because of something else. In case you are using query in Power bi or View at source, check those too

Re: Divide by zero error

kristel_tulio — Fri, 11 Nov 2022 02:43:10 GMT

Thanks amitchandak, will check those

topic Divide by zero error in DAX Commands and Tips

Divide by zero error

Re: Divide by zero error

Re: Divide by zero error