Error in Dax formula

[ilcaa72]

i have a Dax formula that I use successfully in a bar chart with region data, BUT when i try to use it with a different category (Countries) it "cant display the visual"... im having trouble trying to troubleshoot the source of the error, can someone take a look? https://1drv.ms/u/s!AiL3mI_trBnxgxDFo4oupkQnbvFU

[Phil_Seamark · Accepted solution]

HI @ilcaa72

Your formula is fine, the problem is your data is causing the function to overflow.  If you wrap some crude error handling around your RETURN statement as follows

return 
  iferror(if (blank(),0,((SubNow/Sub6yrsAgo)^(1/3))-1),"Has Error")   

You will see that two rows have issues

Neither of these has a value for the Sub6yrsAgo, so the divide fails

Another option is to use the DIVIDE function to gracefully handle the issue

return 
  if (blank(),0,(DIVIDE(SubNow,Sub6yrsAgo,blank())^(1/3))-1)