Forum Discussion
Error in Dax formula
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
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)
1 Reply
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)