Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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)
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |