MdxScript(Model)(17,3) calculation error

Hi AnnieV,

Thank you for reaching out to the Microsoft Fabric Forum Community.

To safely calculate the nth root of a product in Power BI without running into overflow errors, you should use a logarithmic transformation. Instead of directly computing the product of many values, which can quickly exceed Power BI's numeric limits. you sum the natural logarithms of the values and then apply the exponential function to the average log. This approach gives the same result as the nth root of the product (also known as the geometric mean) but avoids issues with large numbers. In DAX, this is implemented using SUMX over LOG, followed by EXP(LogSum / Count), ensuring stability even with large datasets.

If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.

Thank you & regards,
Prasanna Kumar