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.

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.